CODEWITHSUNDEEP
c#sql-serverinsert
Darqer
Darqer

Reputation: 2887

How to fast fill MS Sql 2005 wit data in c#

I crate temporary table in c# (one column, type int), later I want to put ~40 000 values inside (it will be constantly changing). What is the fastest way of doing it ?

Upvotes: 1

Views: 166

Answers (1)

Khh
Khh

Reputation: 2571

look at SqlBulkCopy.

I would test it first, than look at other solutions.

Upvotes: 3

Related Questions