Bulk deletion in Entities Framework 4

entity-framework

Question

I wish to know if there is a good way to do a bulk delete or delete multiple rows using the Entities Framework 4. I can't seam to find a DeleteAll command. The only one that is available is DeleteObject() which only takes one entity, I would like to perform a delete on a list of entities.Is there a better way than to loop trough the list? I did see an article that used ExecuteStoreQuery and created some sql that would perform the delete. Is there a better way than to perform any of these two options Please advice what is the best way to perform this action.

1
8
4/6/2010 10:53:19 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

There isn't an elegant way to do this as of yet. You're correct, you'll have to loop through the list.

This SO post has some good discussions on the topic: How do I delete multiple rows in Entity Framework (without foreach)

3
5/23/2017 12:13:31 PM

Related Questions

LINQ to Entities bulk deletion

The question is an old one (from before EF5 existed). For anyone who's using EF5, ...EntityFramework.Extended... does this in a snap.
c# database entity-framework linq linq-to-entities
asked by Shaul Behr

With Object Framework 4, how do I remove a child entity from a parent collection?

What I've come across to solve this problem is the follwoing override on the DbContext:...public override int SaveChanges() { Set<Child>() .Local .Where(r => !Parent.Local.SelectMany(s => s.Children).Contains(r)) .ToList() .ForEach(r => Set<Child>().Remove(r)); return base.SaveChanges(); } ...Take a look here: ...http://blo...
cascading-deletes entity-framework
asked by Guillermo Ruffino

Entity Framework deletes related entities in a cascading manner.

Instead of on the EF designer, one can also set cascade deletion on the FK Constraints in the database....Here are the visual steps from Sql Server Management Studio (SSMS) on how to setup cascading deletes. ...Note when done, don't forget to ...update the edmx... against the database before attempting a delete....I discuss this in more depth on my...
cascading-deletes entity-framework
asked by ΩmegaMan

bulk delete in entity framework

There is no currently supported bulk delete baked into Entity Framework. Its actually one of the features being discussed on codeplex now EF is open-source. ...EntityFramework.Extended... provides batch delete support (you can find this in nuget) however my experience is that it has some performance issues.
c# entity-framework linq-to-sql
asked by Not loved

Connection closed when doing Transaction rollback on Mysql with Entity Framework 6 and Devart provider

I downloaded the new version 8.1.45 of Devart DotConnect and this has solved the problem completely. Now my transactions get a rollback if any query in them gets an error. And I get the correct exception in my EF6 Executionstrategy....So problem solved. Thx Devart. :)
c# devart entity-framework-6 mysql transactions
asked by Steven Engels

Entity Framework 6 Where in Bulk Update/Delete in one transaction

Unfortunately, this is not supported in Entity Framework out of the box. However, you can use the batch update functionality in the ...EntityFramework.Extended... library:...https://github.com/loresoft/EntityFramework.Extended...There's a nuget package available, too....An example would be:...using EntityFramework.Extensions; ... int[] myIds = { ...
c# entity-framework-6
asked by Dave R.

Entity Framework selectively save tracked entities from context and bulk insert others

A suggestion would be to not attach the ...ProjectRecords... to the context in the first place when loading them from if that's possible. You could use something like a...Dictionary<Project, List<ProjectRecord>> ...to hold them and to help in retrieving the ...Project... and setting ...ProjectRecord.Project... when you save.
bulkinsert c# entity-framework sqlbulkcopy
asked by jjj

Entity Framework bulk inserts - creating a large number of objects / entities is the slow part?

Just use a bulk insert. Even if you get past EF's ridiculously bad performance, you still have to contend with the database not liking individual inserts.
c# entity-framework entity-framework-6
asked by Jonathan Allen

Entity Framework: how to delete related entity upon update or delete of 'generic' parent

you can do as follow: ...public abstract class Picture { public int Id {get;set;} public string Type { get; set; } public byte[] Content { get; set; } } public class ProductImage:Picture { public int ProductId {get;set;} public virtual Product Product {get;set;} } public class CustomerImage:Picture { public int CustomerId {g...
c# cascading-deletes entity-framework entity-framework-6
asked by Lucian Bumb

Bulk insert records and get their Id's after bulk insert in Entity Framework

There is no ...Bulk Insert... in Entity Framework. You must use a third-party library to perform this kind of operation....By default, Entity Framework will make a database round-trip for every entity to save. So more than 100,000 database round-trip will be required in your scenario which is ...INSANELY... slow....Disclaimer...: I'm the owner of ....
c# entity-framework entity-framework-6 sql
asked by Jonathan Magnan

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow