Efficient way to do bulk insert/update with Entity Framework

by

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.

More Related Contents:

  1. How do I view the SQL generated by the Entity Framework?
  2. EF Core Second level ThenInclude missworks
  3. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  4. Convert value when mapping
  5. Disable lazy loading by default in Entity Framework 4
  6. Best way to check if object exists in Entity Framework? [closed]
  7. How to select top N rows for each group in a Entity Framework GroupBy with EF 3.1
  8. How to include a child object’s child object in Entity Framework 5
  9. EF5 Code First Enums and Lookup Tables
  10. Entity Framework 4.1 DbContext Override SaveChanges to Audit Property Change
  11. Entity Framework One-To-One Mapping Issues
  12. Entity framework code-first null foreign key
  13. How can I delete 1,000 rows with EF6?
  14. Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
  15. Entity Framework 4 selective lazy loading properties
  16. When should I call SaveChanges() when creating 1000’s of Entity Framework objects? (like during an import)
  17. Adding Validation Attributes With an Entity Framework Data Model
  18. How to exclude one table from automatic code first migrations in the Entity Framework?
  19. Ramifications of DbSet.Create versus new Entity()
  20. ef core 2 apply HasQueryFilter for all entity
  21. Value cannot be null. Parameter name: entitySet
  22. SQL Server Express connection string for Entity Framework Code First
  23. Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
  24. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  25. EF Code First DBContext and Transactions
  26. How can I disable migration in Entity Framework 6.0
  27. How do I use Entity Framework in Code First Drop-Create mode?
  28. Many to Many Relationships not saving
  29. DbContext AutoDetectChangesEnabled set to false detecting changes
  30. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key

Leave a Comment