p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   BOOK: Professional ASP.NET MVC 2 (http://p2p.wrox.com/forumdisplay.php?f=588)
-   -   How to do bulk insert? (http://p2p.wrox.com/showthread.php?t=81719)

SZhang November 27th, 2010 03:52 AM

How to do bulk insert?
I am learning to create an application using MVC 2 and Entity Framework 4.

In the application, I read some data from an Oracle database, process them, then save to a SQL 2008 database table. I use Enterprise Library to read from the Oracle DB and put the data in Reader, use Entity Framework 4 to access the SQL DB.

From this book, can't know how to do bulk insert. Can you please give me some guidance on how to pass the dataset to the stored procedure for the bulk insert, and how to call the stored procedure from controller.

Thank you very much in advance

j12smith December 12th, 2010 04:26 PM

Is cmd.ExecuteNonQuery() executed within each iteration ?

increase blog traffic

All times are GMT -4. The time now is 10:35 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.