can we write update statement in linq?
example:
var query = Update customer set isEdit = 1 where id = 1
Thanks
Asked
Active
Viewed 6,833 times
3 Answers
5
No, you can't. The Q in LINQ stands for Query.
What you can do is the following:
foreach(var c in customer.Where(x => x.Id == 1))
c.isEdit = 1;
Daniel Hilgarth
- 171,043
- 40
- 335
- 443
-
In Linq To SQL, doesn't this function hit the database for each row? – Cyril Gandon Apr 22 '13 at 07:34
-
@Scorpi0: Most likely, yes. But because the ID of a customer is probably a unique key this doesn't really matter because there only is one row. – Daniel Hilgarth Apr 22 '13 at 07:37
-
I find this pretty dangerous for a beginner. Maybe customer.Where(x => x.Id == 1).FirstOrDefault() is more indicate for the OP. – Cyril Gandon Apr 22 '13 at 07:39
-
@Scorpi0: That would have changed the meaning of the query. – Daniel Hilgarth Apr 22 '13 at 07:40
3
You can shortcut the updates by doing a 'looks like Linq' query, using the ForEach method of the class List:
var toUpdate = customer.Where(c => c.id == 1).ToList();
toUpdate.ForEach(c => c.isEdit = 1);
Cyril Gandon
- 16,830
- 14
- 78
- 122
1
Yes you can, see my answer here.
Foo foo=new Foo { FooId=fooId }; // create obj and set keys
context.Foos.Attach(foo);
foo.Name="test";
context.SubmitChanges();
In your Dbml set UpdateCheck="Never" for all properties.
This will generate a single update statement without having to do a select first.
