Using ODP.NET To Insert Multiple Rows Within A Single Round Trip
Author:
Steven M. Swafford
Have you ever had the necessity to insert multiple rows into a database? Of course you have. In this article I will explain how to make the most of Oracle’s ODP.NET Data Provider to easily pull off such a task. The class we will specifically be looking at to bring about this action is OracleCommand which is part of the Oracle.DataAccess.Client NameSpace. The property which allows you to achieve a multiple row insert is called ArrayBindCount. In this article I will be using a stored procedure instead of a SQL statement.
More Tutorials
|