CODEWITHSUNDEEP
c#
sankar
sankar

Reputation: 75

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 obj = new SqlBulkcopy("TableName");

Upvotes: 4

Views: 4847

Answers (2)

TalentTuner
TalentTuner

Reputation: 17556

SqlBulkCopy class is only designed to work with SQL Server database and works with SQlClient.

There is no counterpart in Oledb

Upvotes: 2

Marc Gravell
Marc Gravell

Reputation: 1063383

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.

Upvotes: 3

Related Questions