Why is my Linq query not updating the DB?

Question

Wondering if anyone can see why i am getting the error "Row not found or changed." when i perform this LINQ query.

The row is there and the data is being picked up ok, but when it comes to update i am getting the error mentioned above.

aboDataDataContext dc = new aboDataDataContext();

        var orders = dc.GetOrderToAcknowledges;

        //Get the TWE Order ID and Store in DB.
        foreach (var order in orders)
        {
            int orderId = dc.amzOrders.Single(o => o.amzOrderId == order.amzOrderId).id;
            DateTime now = DateTime.Now;

            GetTWEOrderID(orderId, now.ToString());

            amzOrder orderUpdate = dc.amzOrders.Single(o => o.id == orderId);
            orderUpdate.acknowledged = true;
            orderUpdate.lastUpdate = Convert.ToDateTime(now);

            dc.SubmitChanges();

        }

possible duplicate of [Linq row not found or changed](http://stackoverflow.com/questions/8851482/linq-row-not-found-or-changed) — Mahmoud Gamal, Sep 20 '12 at 13:04
Did you tried to move dc.SubmitChanges(); outside the foreach loop? — Vytalyi, Sep 20 '12 at 13:06
Could you please specify which line is throwing an exception? — Vytalyi, Sep 20 '12 at 13:11
@DaveHogan thanks for your suggestion, managed to work it out from that :) — thatuxguy, Sep 20 '12 at 13:19

score 0 · Answer 1 · answered Sep 20 '12 at 13:16

Make sure that the designer shows the exact same fields for your entities like your database schema.

This error often occurs when there are changes in the database that were not updated in the entities.

For example a table column might be changed to allow for null values but the entities were not updated to recognize the change.

score 0 · Accepted Answer · answered Sep 20 '12 at 13:18

Worked it out, looked into what DaveHogan said, and moved it around a bit also updated things a little...

var ou = dc.amzOrders.Single(o => o.amzOrderId == order.amzOrderId);
int orderId = ou.id;
DateTime now = DateTime.Now;

ou.acknowledged = true;
ou.lastUpdate = Convert.ToDateTime(now);

dc.SubmitChanges();

GetTWEOrderID(orderId, now.ToString());

Why is my Linq query not updating the DB?

2 Answers2