Register now or log in to join your professional community.
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
Save10 Records into datatable first and then Pass that datatable into stored procedure
If you mean saving bulk of data, I am doing this by using Entity Framework, or you can check SqlBulkCopy class.