Bulk deletion in Entities Framework 4

entity-framework

Question

If there is a suitable approach to mass delete or remove several rows using Entities Framework 4, please let me know. There doesn't seem to be a DeleteAll command. I want to remove a list of entities, however the only one that is accessible is DeleteObject(), which only accepts one item. Is there an alternative to iterating over the list? I did come across an article that prepared some sql and used ExecuteStoreQuery to carry out the deletion. Is there a more effective method than executing any of these two choices? Please advise on the most effective manner to carry out this task.

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 currently a classy method to do this. You'll need to loop through the list, you're right.

How do I remove many rows at once using Entity Framework? (without foreach) This SO post contains some interesting conversations on the subject.

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

Related Questions

LINQ to Entities bulk deletion

The inquiry is dated (from before EF5 existed). For anybody running EF5, ...EntityFramework.Extended... accomplishes this quickly.
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?

The following override on the DbContext is what I've found to fix this issue:...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(); } ...Look at this: ...http://blog.oneunicorn.c...
cascading-deletes entity-framework
asked by Guillermo Ruffino

Entity Framework deletes related entities in a cascading manner.

Cascade deletion may also be specified on the FK Constraints in the database instead of the EF designer....Here are the visual instructions for setting up cascading deletes via SQL Server Management Studio (SSMS)....When finished, remember to run ...modernize the edmx... against the database before trying to remove anything....I go into more detail...
cascading-deletes entity-framework
asked by ΩmegaMan

bulk delete in entity framework

Entity Framework does not presently allow mass deletion. Now that EF is open-source, it's actually one of the features being debated on Codeplex....EntityFramework.Extended... offers support for batch deletion (you can find this in nuget), however based on my experience, it has some performance difficulties.
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 updated Devart DotConnect to version 8.1.45, and this entirely fixed the issue. My transactions are now rolled back if any of their queries encounter errors. And in my EF6 Executionstrategy, I receive the appropriate exception....Solution achieved. Thanks, Devart.
c# devart entity-framework-6 mysql transactions
asked by Steven Engels

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

ZZZ_tmp
c# entity-framework-6
asked by Dave R.

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

I would advise against attaching the...ProjectRecords... If it's feasible, load them from the context in the first place when loading them. An example of something you might use...Dictionary<Project, List<ProjectRecord>> ...to keep them and assist in locating the...Project... as well as...ProjectRecord.Project... every time 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?

ZZZ_tmp
c# entity-framework entity-framework-6
asked by Jonathan Allen

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

ZZZ_tmp
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 doesn't...Bulk Insert... Entity Framework, For this type of activity, a third-party library is required....Every time an entity is saved, Entity Framework by default does a round trip to the database. Therefore, in your situation, more than 100,000 database round-trips will be needed, which is ...INSANELY... sluggish....I possess ...Extended ...
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