skip to main content
Using the ADO.NET Client : Specifying Connection Options : Parameter Mode
 

Parameter Mode

Description

Parameters that are passed by name instead of relying on its position in the parameter list.

Valid Values

ANSI | BinByOrdinal | BindByName

Default

An empty string
If set to ANSI, the '?' character is processed as a parameter marker and bound as ordinal.
If set to BindByOrdinal, native parameter markers are used and are bound as ordinal for stored procedures and standard commands. Native parameter marker in this case is '?'
If set to BindByName, native parameter markers are used and are bound by name. '@' parameter marker is supported in a prepared statement. Native Parameter marker in this case is @.