Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

More Than 10 Rows of ASP.NET Application Data table, how to save / insert in Database (Oracle 11g) in one Database Hit?

user-image
Question added by Muhammad Razzaq , Assistant Director IT , Punjab Education Foundation
Date Posted: 2014/06/09
Deleted user
by Deleted user

you can Use SQL SCRIPT wich is a set of SQL commands saved as a file in SQL Scripts. A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL Scripts to create, edit, view, run, and delete script files.at last in script file use commit or commitretaining for validation of all operation

http://www.bayt.com/fr/specialties/q/7217/how-to-handle-a-huge-concurrent-inserts-on-a-database-table/?feed=top_stories

 

Quresh Hatim Ali Pan wala
by Quresh Hatim Ali Pan wala , senior Team Lead , Talabat.com

Save10 Records into datatable first and then Pass that datatable into stored procedure

osama Al Ansari
by osama Al Ansari , Technical Delivery Manager , THIQAH Business Services

If you mean saving bulk of data, I am doing this by using Entity Framework, or you can check SqlBulkCopy class.

More Questions Like This