How can I Do OLEDB BulkCopy to insert bulkrecords?
I have used SqlBulkCopy to insert bulkrecords into database. Now i want to change it as Oledb Connections. So i need to Change my bulkcopy..
How can i do same in the oledb?
SqlBulkcopy o开发者_高级运维bj = new SqlBulkcopy("TableName");
SqlBulkCopy
uses a specific database feature, that has no generic OLEDB counterpart. Individual providers may have something similar, but you would have to use to provider-specific variant (or find a library that already wraps this, if one).
In short: as far as I know, you can't.
SqlBulkCopy class is only designed to work with SQL Server database and works with SQlClient.
There is no counterpart in Oledb
精彩评论