SqlBulkCopy Tutorial - Knowledge Base (KB)

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