Efficient way to do bulk insert/update with Entity Framework

Just don’t use Entity Framework in this case. Just use a stored procedure (how to depends on the version/approach you use with EF, you might will have to extend your DbContext or add a mapping from the entity model).

If you’re using SQL Server, then in your store procedure, do use the MERGE command that efficiently does exactly what you need: insert if it doesn’t exist, or update if it does. Everything in a single, efficient SQL query.

Related Contents:

  1. Code First: Independent associations vs. Foreign key associations?
  2. Entity Framework: “Store update, insert, or delete statement affected an unexpected number of rows (0).” [closed]
  3. EF Core Second level ThenInclude missworks
  4. How do I delete multiple rows in Entity Framework (without foreach)
  5. Entity Framework 6 Code first Default value
  6. Entity Framework – Why explicitly set entity state to modified?
  7. ORM Entities vs. Domain Entities under Entity Framework 6.0
  8. Improving bulk insert performance in Entity framework [duplicate]
  9. Disable lazy loading by default in Entity Framework 4
  10. Batch update/delete EF5
  11. EntityFramework code-first custom connection string and migrations
  12. EF Code First “Invalid column name ‘Discriminator'” but no inheritance
  13. How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?
  14. How do I detach objects in Entity Framework Code First?
  15. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  16. No executable found matching command “dotnet-ef”
  17. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  18. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  19. How to ensure proxies are created when using the repository pattern with entity framework?
  20. mapping private property entity framework code first [duplicate]
  21. Debug code-first Entity Framework migration codes
  22. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  23. Cascading deletes with Entity Framework – Related entities deleted by EF
  24. EF Query With Conditional Include
  25. Entity framework core update many to many
  26. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  27. Entity framework code-first null foreign key
  28. EF can’t infer return schema from Stored Procedure selecting from a #temp table
  29. Using EF Core ThenInclude() on Junction tables
  30. Entity Framework 4 / POCO – Where to start? [closed]
  31. How can I disable migration in Entity Framework 6.0
  32. How do I singularize my tables in EF Code First?
  33. What is the syntax for self referencing foreign keys in EF Code First?
  34. Entity Framework: Ignore Columns
  35. Entity Framework CTP 4 – Code First Custom Database Initializer
  36. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import) [duplicate]
  37. Entity Framework: Re-finding objects recently added to context
  38. Why is my Entity Framework Code First proxy collection null and why can’t I set it?
  39. Entity Framework 4.1+ many-to-many relationships change tracking
  40. Querying objects after AddObject before SaveChanges?
  41. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  42. EF Core 2: How to apply HasQueryFilter for all entities
  43. How to delete an object by id with entity framework
  44. what is difference between a Model and an Entity
  45. LINQ to Entities for subtracting 2 dates
  46. Mocking or faking DbEntityEntry or creating a new DbEntityEntry
  47. Error 6002: The table/view does not have a primary key defined
  48. Map two different entities to the same table?
  49. How do I use Entity Framework in Code First Drop-Create mode?
  50. check constraint entity framework

Leave a Comment