Articles

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

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

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

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

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