SqlBulkCopy Tutorial - Knowledge Base (KB)

How do I convert a generic list to a DataReader in.NET?

Hi I have a Populated Generic List in a winform and now wanna to send its data into a SQL server table as a bulk Copy. As I read the SqlBulkCopy Class, it needs a data reader as a source....Now, how can I convert it to a DataReader?...Thank you

Fire trigger for every inserted row using SqlBulkCopy

I am using ...SqlBulkCopy... class to insert 50k rows at a time in table ...tbl_records... I have set a ...After Insert... trigger on this table and using following code...SqlBulkCopy SqlBc1 = new SqlBulkCopy(strConnString, SqlBulkCopyOptions.FireTriggers...

C# WinForms - SQL Server CE - SqlCeDataReader loses its data?

I am trying to copy data from SQL Server database to SQL Server CE local database....Here is my method :...private const string LOCAL_SDF_FILE = "LocalDB.sdf"; private const string LOCAL_CONN_STRING = "Data Source='|DataDirectory|LocalDB.sdf'; LCID=1033; ...