将linq更新为实体

Question

Am正在尝试编写一个linq-to-entity更新查询，相当于下面的sql查询

update INVOICES set STATUS=1 where INVOICE=165438    

我的Linq到实体

 var db = new MyEntities();
            var query =
            from t in db.INVOICES
            where
            t.INVOICE1 == "165438"
            select t;
            foreach (var t in query)
            {
                t.STATUS ="1";
            }
            db.SaveChanges();

不确定，请有人帮我。

感谢

Answer 1

用EntityState.Modified标记实体，告诉EntityFramework在数据库中更新它

var query = /*Your query*/;
foreach (var t in query)
{
    t.STATUS ="1";
    db.Entry(t).State = System.Data.EntityState.Modified;
}
db.SaveChanges();