SqlBulkCopy Tutorial - Knowledge Base (KB)

DataTables In Async Methods

I have created some async methods and have been adding records to a dataTable in those methods, and then bulk copying the dataTable after the async methods are done. I've found now that dataTables are not thread-safe, and that is the source of my problem,...

psycopg2 copy_from raises asynchronous ProgrammingError with sync connection in celery task

My problem is I am facing...ProgrammingError: copy_from cannot be used with an asynchronous callback....while trying to ...copy_from... without async connection. This must be stated, I am creating connection from a celery task. Can someone give me a clu...

Async for Bulk copy

I have quite a few datatable to bulkinsert into databasetable Due to large size, one table took 5 min to complete insert. 2 tables took me 10 min...static void Main(string[] args) { DataTableBulkInsert(DataTable1); DataTableBulkInsert(DataTable2);...

BulkCopy.WriteToServerAsync() Not Working Importing Records

I wrote a routine to bulk import records. It is not working and I think the problem is that I don't have any kind of await in here but I don't know how or where to put it in. Due to the nature of my project, I don't want the method to be an async method...