How much bulk data can be entered at a time in asp.net mvc

Ashish Mishra

i am developing a multilevel marketing website where i need to have 8000 record entry in bulk i have two approach which i came to know while researching on this topic first is SulBulkCopy and second is TVP with Stored Procedure what will be better approach in both of these and one more thing these 8000 records keep on growing it can go to one lackhs as well and more than that even provide me solution i am using mvc by c# and my backend is sql server 2014

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel8y ago
HI Ashish,

As of now , we just inserting 1000 records using dapper bulk insert. Its really good and faster then entity framework.

We are not yet inserted 8000 records. You can check yourself. But I am sure dapper is a faster tool which we can perform database operations compare then entity framework.

All the best. Do well.
0
Ashish Mishra8y ago
It will be difficult for me to switch to dapper because project is already constructed using entityframework and raw sql query using sqlconnection.but one thing that i would like to know from your end as you are alredy using dapper and being experienced candidate how much records can easily be entered with bulk data as my current list having 8000 records and it keeps on growing in future
0
Ramesh Palanivel8y ago
Hi Ashish,

Please look on dapper, we are using dapper for some bulk insert records in our project

http://dapper-tutorial.net/bulk-insert
0