SQL Bulkcopy using DATA Access block

Question

I am using the below piece of code for SQL Bulk copy

using (SqlConnection con = new SqlConnection(strConString))
{
con.Open();
SqlBulkCopy sqlBC = new SqlBulkCopy(con);
sqlBC.DestinationTableName = "SomeTable";
sqlBC.WriteToServer(dtOppConSummary);
}

Can anyone provide me the equvalent code using Data access block Enterprise library

cortijon · Accepted Answer · 2010-04-19 14:02:24Z

1

Unfortunately, there is not a bulk copy pattern out of the box with the DAAB. The SqlBulkCopy class does not implement any interfaces besides disposable.

If you want to use bulk copy in a DAAB environment, you will have to modify your DAAB implementation to include it. Some steps you'll have to take are:

Create an `IDbBulkCopy interface
Create a wrapper class that implements the `IDbBulkCopy interface and wraps SqlBulkCopy
If you need access Oracle, implement the `IDbBulkCopy interface to use ADO.NET's "Array Binding" feature.

answered Apr 19, 2010 at 14:02

cortijon

9836 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Goatly · Accepted Answer · 2010-04-19 13:58:00Z

0

I'm not sure if that's going to be possible because the point of the data access block is to abstract you away from a specific data source. SqlBulkCopy if specific to the SqlClient libraries, and I don't think there's a generic way of doing this kind of operation across other data sources.

answered Apr 19, 2010 at 13:58

Mike Goatly

7,6782 gold badges36 silver badges35 bronze badges

4 Comments

SSK Over a year ago

Ok can i replace the sql connection object with data access block??

SSK Over a year ago

or this is the best way to handle this??

Mike Goatly Over a year ago

I guess I should have asked why you are keen to try and use the data access block anyway... I'm not sure that you want to be using the data access block for this - you're using a SQL Server specific feature, so any benefit of going through the data access block is gone...

SSK Over a year ago

actually other my other code i have converted to DAAB and this is the only piece of code left and hence i had posted this query

Collectives™ on Stack Overflow

SQL Bulkcopy using DATA Access block

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related