How can I make OLEDB BulkCopy to insert voluminous records?

Question

I used SqlBulkCopy to insert bulk records into a database. Now I want to change it as Oledb Connections. Therefore, I need to change my large copy.

How can i do the same in oledb?

SqlBulkcopy obj = new SqlBulkcopy("TableName");

Answer 1

SqlBulkCopyuses a special database function that does not have a common analogue of OLEDB. Individual providers may have something similar, but you will have to use a vendor-specific option (or find a library that already wraps this, if any).

In short: as far as I know, you cannot.

Answer 2

The SqlBulkCopy class is intended only for working with a SQL Server database and works with SQlClient.

Oledb