Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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 ajoutée par Muhammad Razzaq , Assistant Director IT , Punjab Education Foundation
Date de publication: 2014/06/09
Utilisateur supprimé
par Utilisateur supprimé

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
par 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
par 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