Improve data Insertion performance in entity framework || Fatest way to insert huge data in entity framework C#.NET
Introduction In this article i will talk about how to improve performance when you want to insert records using entity framework, and how you can add and use bulk insert extension in visual studio. The basic idea is to reduce the hits on database server as possible, the worst case is to insert each record in database hit. Practical Performance testing : I'm prepared simple practical test for entity framework performance for inserting data.And i take five methods of insert in test comparison as following : Bulk Insert Extension.(i will explain how to install it from nuget) AddRange method. Add method with one SaveChanges(). Add method with one SaveChange() for each 100 record. Add method with SaveChanges() for each record. Test Results : Bulk Insert Extension Installation As we notice , bulk insert is the faster method for insert data especially huge data in entity frame...