The Ingres .NET Data Provider now supports named parameters in queries. Named parameters allow the parameter values to be set regardless of the order that they appear in the SQL statement.

A named parameter marker consists of an initial character of question mark (?), at-sign (@), or colon (:) followed by a name. The name is an alphanumeric identifier or an integer. Although the recommended parameter marker character is the question mark, the Ingres .NET Data Provider supports all three characters to ease migrations from other database products.

Prior releases supported the unnamed (positional) parameter marker placeholder syntax using the question mark (?), similar to ODBC and JDBC.

Using named and unnamed parameters in the same SQL statement is not allowed.

For more information, see the Connectivity Guide.