ado.net entity framework delete rows

Question

I may be completely blind and stupid, but I cannot find any method generated by ADO.NET Entity Data Model that would somehow delete rows from my table. I didn't want to create a custom query. So how do I do that? Please help.

I don't have the method DeleteOnSubmit... don't know why. This is the code I wanted to use.

var deleteOrderDetails =
from details in db.OrderDetails
where details.OrderID == 11000
select details;

foreach (var detail in deleteOrderDetails)
{
db.OrderDetails.DeleteOnSubmit(detail);
}

db.SubmitChanges();

Daniel Elliott · Accepted Answer · 2009-09-08 14:22:32Z

10

A couple of alterations needed:

db.DeleteObject(detail);

and

db.SaveChanges();

Kindness,

Dan

PS: Have you been using Linq to SQL and then swapped to the Entity Framework?

answered Sep 8, 2009 at 14:22

Daniel Elliott

22.9k10 gold badges67 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Trimack Over a year ago

Yes. That would be the case. Also - can I delete multiple rows at once by this?

Daniel Elliott Over a year ago

You can do mutiple delete objects per SaveChanges, yes :)

Trimack Over a year ago

No, what I meant was if I could do dv.DeleteObject(deleteOrderDetails);??

ncubica Over a year ago

make a list of objects you can remove and then iterate appyling the Contetxt.Model.Remove(item); when finish your iteration simply apply Context.SaveChanges and should works

Community · Accepted Answer · 2017-05-23 11:44:01Z

6

Here's another way (thanks to this answer)

I assume you have the Orders table, and OrderDetails is related to it via OrderID.

var order = db.Orders.FirstOrDefault(o=> o.OrderID == 11000);
if(order != null)
{
  order.OrderDetails.Clear();
  db.SaveChanges();
}

This should delete all the order details associated with that order.

edit: fixed the code

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Dec 1, 2010 at 9:23

roman m

26.6k32 gold badges106 silver badges136 bronze badges

Collectives™ on Stack Overflow

ado.net entity framework delete rows

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related