zzz projects Entity Framework 6 EF 6
Home EF Core 5 Articles Knowledge Base Online Examples
  • Home
  • EF Core 5
  • Articles
  • Knowledge Base
  • Online Examples

Articles

5 results for:

Bulk Insert

BulkInsert...When you want to insert hundreds, thousands, or millions of entities using ...SaveChanges()... method, you will notice that your application performance is INSANELY slow....The ...SaveChanges()... requires one database round-trip for every entity to insert....For example, if you need to insert 10000 entities, then 10000 database round-trips will be performed and your application suffers from performances issues....BulkInsert...Entity Framework Classic provides an extension method ..
saving insert bulk-insert

Fastest Way to Insert

Fastest Way To Insert...What's the fastest way to insert?...When you want to insert hundreds, thousands, or millions of entities, and your application suffers from performances issues....StackOverflow Related Questions...Fastest Way of Inserting in Entity Framework...Writing to large number of records take too much time using Entity Framework...Answer...BulkInsert...There are many solutions to insert many records in the fastest way, but the most significant and recommended solution is BulkInsert...
saving insert bulk-insert

Identity Insert

Identity Insert...In Entity Framework, when you have a primary key field such as ...Id... or ...AuthorId... which is mapped to ...IDENTITY... column in the database, it works well when you insert data....In some cases, you might need to insert explicit values into a SQL Server ...IDENTITY... column....To do so, you need to enable ...IDENTITY_INSERT... before calling ...SaveChanges()... manually....Let's say we want to create a new author with explicit ...AuthorId... value....Author author = new ...
saving insert identity

Insert Multiple Entities

Insert Multiple Entities...How to Insert Multiple Entities at Once?...When you want to insert hundreds, thousands, or millions of entities in one go....StackOverflow Related Questions...Entity Framework 6 DbSet AddRange vs IDbSet Add - How Can AddRange be so much faster?...Bulk insert using AddRange in Entity framework [closed]...Answer...AddRange...The AddRange method is used for adding multiple objects to the database in one method call. The following code inserts a large number of records int...
save insert bulk-insert

Insert Records

Insert Records...How to do a Bulk Insert?...Inserting thousand of entities for an initial load or a file importation is a typical scenario....SaveChanges... method makes it quite impossible to handle this kind of situation directly from Entity Framework due to the number of database round-trips required....SaveChanges requires one database round-trip for every entity to insert. So if you need to insert 10000 entities, then 10000 database round-trips will be performed which is ...INSANELY... slow...
save insert bulk-insert

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

Try for free now