SqlBulkCopy Tutorial - Knowledge Base (KB)

Datareader from LINQ Query for SqlBulkCopy

I'm using this library:...Link to EntityDataReader...to put some linq query results from a xml parse to a database with a sqlbulkcopy which us es a datareader to put the data directly without using datatables or such data structures....I am not able to im...

Insert Dictionary elements into SQL table as rows using IDatareader and SqlBulkCopy

I need to improve dramatically the execution time of a process wich currently is just like this:...private Dictionary<int, SingleElement> elements_buffer; // ... Create and load values into "elements_buffer" // (string, Datetime, double) string query = ...

How to avoid Error "There is already an open DataReader associated with this Command" in MSSql 2000

I am using SqlBulkCopy to copy data to 2 separate table in same database....obj_Command.CommandText = "Select * from tmpInvDtlMast where InvNo='111'" Using bulkCopy As SqlBulkCopy = New SqlBulkCopy(con1) bulkCopy.DestinationTab...