Fast SQL Server Inserting Data from .NET

clive All, ASP.Net, Development, Microsoft, Rectangle Red, Tech Tip, Uncategorized, VB.Net

Today we needed to insert a large amount (250,000 rows) of automatically generated data into a SQL Server database. Generating the data was very fast, but inserting each line with a SQL Insert statement, painfully slow, even if logging is in Simple Mode in the SQL database. So… we investigated the SQLBulkCopy function in .NET, but this is usually used …