How to batch insert lots of rows using Enterprise Library DAAB?

Question

How can I execute 1000s of INSERT queries using Enterprise Library DAAB? That is to say how can I insert lots of rows into a table using DAAB all at once efficiently? And without using a for-loop. Thanks.

I updated my answer. You can use ODP.NET. – William Xifaras Jun 23 '16 at 14:29 — William Xifaras, Jun 23 '16 at 14:29

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

Unfortunately, I'm not sure you can do that using the Enterprise Library DAAB without extending it. As an alternative you can use SqlBulkCopy.

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

EDIT

The Oracle Data Provider for .NET (ODP.NET) supports this via the Array Binding feature.

http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59odpnet-085168.html

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 26 '11 at 20:04

William Xifaras

5,212
2
19
21

I'm using an Oracle database. Can't use SqlBulkCopy. – Kayes Oct 26 '11 at 20:11
I would say the OracleDataAdapter(), but that is now obsolete. – William Xifaras Oct 26 '11 at 20:18

How to batch insert lots of rows using Enterprise Library DAAB?

1 Answers1