Parameter Arrays

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 data provider supports input parameter arrays for Insert and Update statements.