How to update Bulk Data in sql Server from C# List

Asked Aug 10 '17 at 07:43

Active Aug 10 '17 at 07:43

Viewed 416 times

I have a List of multiple data(20000 Records),I have insert and update the List from C# to SQL server database.

I have already used Z.EntityFramework.ExtensionMethods but it is paid. SqlBulkCopy is working in Case of Insert only,how to update the dataTable from the List.

asked Aug 10 '17 at 07:43

Aryan Mittal

Check out [this](https://stackoverflow.com/questions/20635796/bulk-update-in-c-sharp) one – boop_the_snoot Aug 10 '17 at 07:46
MS Sql I guess. Create a stored proc with a table-valued parameter and pass the list . – Serg Aug 10 '17 at 07:47
Please provide some code to accompany your question... – IronAces Aug 10 '17 at 07:51
`I have already used Z.EntityFramework.ExtensionMethods but it is paid` What do you mean by this? – mjwills Aug 10 '17 at 07:57
Means Its 3rd party Tool , which paid. – Aryan Mittal Aug 10 '17 at 09:10
Please give me any Suggestions.. – Aryan Mittal Aug 10 '17 at 10:37

How to update Bulk Data in sql Server from C# List

0 Answers0