in ADO.NET I can use
to delete some rows from an SQL table.
what is the equivalent in Entity Framework?
How can I achieve that same result?
updateing with null objects isn't the same.
You need to retrieve the object to be deleted first. For example :
// Assuming ID is primary key in `Customer` entity Customer cust = (from c in context.Customers where c.ID = "1" select c);
Then delete the object using
More : DataContext
Replies telling you, that you need to first fetch objects (strictly speaking keys are enough, but then you need to do some work manually) into memory and mark them for deletion and finally call
SaveChanges. Though that's the "normal" approach, there's bunch of extensions, helpers, ... that allow you to do i.e. batch deletes, batch updates and other helpful stuff.