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

Question

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 ?

Answer 1

Hi,

look at SqlBulkCopy.

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