Last post Jul 08, 2015 04:21 AM by Fei Han - MSFT
Jul 07, 2015 05:05 AM|brucey|LINK
Hi folks, looking for some advice what is the best way to import data from a CSV file to a MS SQL database, I need to transfer the data to the application first, I'm using c#.
Open to ideas....
Jul 07, 2015 05:07 AM|Lokesh B R|LINK
Jul 07, 2015 05:44 AM|Dipen_Chovatiya|LINK
Use Table Type
Jul 08, 2015 03:20 AM|Mikesdotnetting|LINK
Bulk Insert or Sql Bulk Copy (https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy(v=vs.110).aspx)
EF/Linq to SQL/any other ORM tool is not designed for that kind of task.
Jul 08, 2015 04:21 AM|Fei Han - MSFT|LINK
looking for some advice what is the best way to import data from a CSV file to a MS SQL database, I need to transfer the data to the application first, I'm using c#.
This article explained how to insert CSV file data into SQL Server database table using the SqlBulkCopy class, hoping it will be helpful.