bulk delete in entity framework

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.

Bulk deletion in Entities Framework 4

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...

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...

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...

How can I automatically filter out soft deleted entities with Entity Framework?

I am using Entity Framework Code First. I override ...SaveChanges... in ...DbContext... to allow me to do a "soft delete":...if (item.State == EntityState.Deleted && typeof(ISoftDelete).IsAssignableFrom(type)) { item.State = EntityState.Modified; item.Entity.GetType().GetMethod("Delete") .Invoke(item.Entity, null); continue; } ...

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 = { ...

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

I'm fairly new to Entity Framework. I've come across a scenario where I have my entities:...public class Company{ public int Id { get; set; } public string Name { get; set; } public IList<Project> Projects{ get; set; } } public class Project { public int Id { get; set; } public List<ProjectRecord> ProjectRecords { get; set; } ...

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.

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...

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

I want to bulk insert 100,000+ rows into a table (which has a identity column which auto increments every time a new row is inserted)....What would be the fastest way to insert the rows with least performance impact?...After all rows are inserted, how do I get the list of ids of the rows that are recently inserted?...Note: I did the following but I...