Tagged articles - SqlBulkCopy

Found 2 articles tagged with SqlBulkCopy

SqlBulkCopy object collection to database table with C#
Performing SqlBulkCopy with collection of objects as a source data
0
Over the time various techniques to manipulate database data have evolved in .NET. Entity Framework is certainly the most advanced one, but for small ad hock applications where you have few inserts to deal with, ADO is still the fastest way to write data to the database...read more
SqlBulkCopy with model classes in C#
Use SqlBulkCopy with model (POCO) classes in C#
 
0
So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable. Since SqlBulkCopy accepts DataTable for insert you can not use models directly to insert your data...read more

.NET

read more

JavaScript

read more

SQL/T-SQL

read more

Umbraco CMS

read more