Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can LINQ to SQL perform batch updates and deletes? Or does it always do one row update at a time?

0
Posted

Can LINQ to SQL perform batch updates and deletes? Or does it always do one row update at a time?

0

By default, LINQ to SQL will perform a single row update when datacontext.SubmitChanges() is called after many rows have been deleted, or modified. Terry Aney has posted his solution in the form of a few very cool extension methods that support batch deletes and updates. See the article here..

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.