Entity Framework Fastest Way To Insert Improve Save Performance

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 provided by Entity Framework Extensions library. By default, identity value is populated to make it even easier to use.

Performance Comparisons

Steps to use BulkInsert

1. CREATE a list
2. ADD entity to the list
3. USE BulkInsert
4. Done!

using (var ctx = new CustomerContext())
{
    // 1. CREATE a list
    List<Customer> customers = new List<Customer>();
    
    foreach(var line in lines)
    {
        var customer = new Customer();
        // ...code...
        
        // 2. ADD entity to the list
        customers.Add(customer);
    }
    
    // 3. USE BulkInsert
    ctx.BulkInsert(customers);
    
    // 4. Done!
}

Try it online

Alternative to BulkInsert

There are some free third-party libraries alternative to Entity Framework Extensions, they are not hard to find, but we don't recommend them since they work with the simple scenario but fail at supporting complex type, inheritance, and association.

SqlBulkCopy

Using SqlBulkCopy (for SQL Server) is without a doubt the fastest solution (very slightly faster than Entity Framework Extensions) but also the longer to implement.

Be careful; this solution adds some code complexity for the maintenance team.

Steps to use SqlBulkCopy

1. CREATE a list
2. ADD entity to the list
3. CONVERT the list to a DataTable
4. CREATE a SqlBulkCopy instance
5. MAP the SqlBulkCopy to database
6. Use WriteToServer
7. Done!