Home > ASP.Net, Linq > Multiple Delete with Linq

Multiple Delete with Linq


Hi

try this example for Multiple Delete with Linq :-

MyAppDataContext db = new MyAppDataContext();
var objCarFeature = db.CarFeatures.Where(p=> p.Car_ID == CarID);
Dt.DataTire.db.CarFeatures.DeleteAllOnSubmit(objCarFeature);
Dt.DataTire.db.SubmitChanges();

//— another way

NorthwindDataContext context = new NorthwindDataContext();
var products = context.Products.Where(p => p.CategoryID == 1);
context.Products.DeleteAllOnSubmit(products);
context.SubmitChanges();

//— another way

MyAppDataContext db = new MyAppDataContext();
var deleteRelatedRecords = from relatedRecords in db.RelatedRecords
    where relatedRecords.MyForeignKeyID == MyPrimaryKeyID
    select relatedRecords;
foreach (var relatedRecords in deleteRelatedRecords)
{
db.RelatedRecords.DeleteOnSubmit(RelatedRecords);
}
db.SubmitChanges();

Hope this helps

Good Luck

Advertisements
Categories: ASP.Net, Linq
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: