View Single Post
  #1 (permalink)  
Old November 27th, 2010, 03:52 AM
SZhang SZhang is offline
Registered User
 
Join Date: Nov 2010
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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
Susan