Parameter array binding is typically used with Insert statements to speed up the time needed to fill 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 server in a single round trip (depending on the native capabilities of the backend database).
The ADO.NET Client supports input parameter arrays for Insert and Update statements. The data provider supports output arrays for stored procedures.
