Linq update query using join

Question

I just trying to Linq query update with join condition

 var GsOrderUpdate = (from x in ctxParser.Tbl_Order_Hierarchy
                 join y in ctxParser.tbl_GS_Related_Orders
                 on x.RootOrder equals y.RelatedOrder
                 where y.ParentId == sParentId
                 select new
                 {
                     ID = x.ID,
                     RelatedOrderParentId = y.ID
                 });

foreach (var gs in GsOrderUpdate)
{
    gs.RelatedOrderParentId = gs.ID;
}

ctxParser.SaveChanges();

I am hetting this error:

Property or indexer Anonymous type RelatedOrderParentId cant be assigned to it is read only.

How can resolve this problem.

You cannot update anonymous types. You can only update entities. — Yacoub Massad
– Yacoub Massad, Commented Jan 18, 2016 at 13:49
LINQ can be used with many sources of data. Are you using Entity Framework? — Martin Liversage
– Martin Liversage, Commented Jan 18, 2016 at 13:51
Possible duplicate of C# Anonymous types cannot be assigned to -- it is read only — Salah Akbari
– Salah Akbari, Commented Jan 18, 2016 at 13:51
what yo wanna do exactly, what is RelatedOrderParentId which you are trying to update?. — Viplock
– Viplock, Commented Jan 18, 2016 at 13:54
Anonymous types don't have property set methods. stackoverflow.com/questions/26916695/… — Shankaranand
– Shankaranand, Commented Jan 18, 2016 at 13:54

Andrey Burykin · Accepted Answer · 2016-01-18 13:57:45Z

1

You can't use anonymous type to update with EntityFramework. If you want to update try so:

var GsOrderUpdate = (from x in ctxParser.Tbl_Order_Hierarchy
             join y in ctxParser.tbl_GS_Related_Orders
             on x.RootOrder equals y.RelatedOrder
             where y.ParentId == sParentId
             select new
             {
                 Parent = x,
                 Child = y
             });

foreach (var gs in GsOrderUpdate)
{
    gs.Child.RelatedOrderParentId = gs.Parent.ID;
}

ctxParser.SaveChanges();

answered Jan 18, 2016 at 13:57

Andrey Burykin

73812 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yacoub Massad · Accepted Answer · 2016-01-18 14:08:54Z

0

The entity framework does not track changes in anonymous type objects. It only tracks changes in entities.

You can change your code to do something like this:

var GsOrderUpdate = (from x in ctxParser.Tbl_Order_Hierarchy
                 join y in ctxParser.tbl_GS_Related_Orders
                 on x.RootOrder equals y.RelatedOrder
                 where y.ParentId == sParentId
                 select new
                 {
                     ID = x.ID,
                     Order = y
                 });

foreach (var gs in GsOrderUpdate)
{
    gs.Order.RelatedOrderParentId = gs.ID;
}

ctxParser.SaveChanges();

Now, you include the whole entity that you want to update.

edited Jan 18, 2016 at 14:08

answered Jan 18, 2016 at 13:59

Yacoub Massad

27.9k2 gold badges42 silver badges68 bronze badges

Comments

Bappi Datta · Accepted Answer · 2016-01-18 16:53:39Z

0

Use Entity class instead of anonymous object:

var GsOrderUpdate = (from x in ctxParser.Tbl_Order_Hierarchy
                 join y in ctxParser.tbl_GS_Related_Orders
                 on x.RootOrder equals y.RelatedOrder
                 where y.ParentId == sParentId
                 select new YourEntityName
                 {
                     ID = x.ID,
                     RelatedOrderParentId = y.ID
                 });

answered Jan 18, 2016 at 16:53

Bappi Datta

1,3809 silver badges15 bronze badges

Collectives™ on Stack Overflow

Linq update query using join

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related