Binding Parameter Arrays

Parameter array binding is typically used with Insert statements to speed up the time needed to insert data into a table. An application can specify rows of parameter values with a single execution of a command. The values can then be sent to the database in a single round trip (depending on the native capabilities of the database), reducing network traffic.

DataDirect Connect for ADO.NET data providers support input parameter arrays for Insert and Update statements for stored procedures. In addition, the Oracle data provider supports output parameters for array binding.