How to insert/update/delete multiple objects with a single query in Linq to Sql

Question

Linq to Sql handles every insert/delete/update operation on an object with separate query. Is there a way to unite multiple operations in single query?

I know this is not possible with the default behavior of the framework. I'm looking for an extension method or workaround. I want to use the queries generated by Linq to Sql, not my own queries or stored procedures but unite multiple operations in a single round-trip to the database.

Answer 1

LINQ to SQL does not give you a way to specify a set-based update/delete against the database. The only alternative that I am aware of is to use use SQL directly, which you can do using the database context object.

Randy

Answer 2

look at this post : http://stackoverflow.com/questions/1952677/how-to-run-a-mass-update-delete-query-in-linq/1953244#1953244

It's a link to how to implement a batch update, batch delete ... hope it helps