SqlBulkCopy Tutorial - Knowledge Base (KB)

EF6 data context throws stackoverflow exception after SqlBulkCopy insrt large data

I have a situation, consider:...SQL Server 2014 Database with table T1....WPF application that has EF6 to maintain data in table T1....Application is running OK....When app starts, if table T1 is empty (0 records), SqlBulkCopy is used to insert 5000 recor...

Cannot convert from system.data.common.dbconnection to system.data,sqlconnection

I am importing data from my excel file to sql database. I am using MVC 5 and entity framework 6. I am using epplus to import the data and sqlbulkcopy to import the data to sql. I am getting 3 errors: 1) excelImportDBEntities.Database.Connection 2) sqlbulk...

Import Excel file into database using Epplus and Sqlbulkcopy in MVC 5

I am importing a large data file from excel into my database table using Epplus library in MVC5 and Entity Framework 6. It is taking alot of time to copy that file to the database. I am looking to use sqlbulkcopy to insert the data quickly but I am not re...