Post
Ask Question

Different Way to Update Database using LINQ

In order to update the database using SaveChanges() method, following are the ways to do this.

Option 1
  1. var ls=new int[]{2,3,4};  
  2. var name="Foo";  
  3. using (var db=new SomeDatabaseContext())  
  4. {  
  5.     var some= db.SomeTable.Where(x=>ls.Contains(x.friendid)).ToList();  
  6.     some.ForEach(a=>  
  7.     {  
  8.          a.status=true;  
  9.          a.name=name;  
  10.     }  
  11.     );  
  12.     db.SubmitChanges();  
  13. }  
Option 2
  1. using (var db=new SomeDatabaseContext())  
  2. {  
  3.     db.SomeTable  
  4.         .Where(x=>ls.Contains(x.friendid))  
  5.         .ToList()  
  6.         .ForEach(a=>  
  7.         {  
  8.              a.status=true;  
  9.              a.name=name;  
  10.         }  
  11.         );  
  12.     db.SubmitChanges();  
  13. }  
Option 3
  1. using (var db=new SomeDatabaseContext())  
  2. {  
  3.     foreach (var some in db.SomeTable.Where(x=>ls.Contains(x.friendid)).ToList())  
  4.     {  
  5.         some.status=true;  
  6.         some.name=name;  
  7.     }  
  8.     db.SubmitChanges();  
  9. }