iBATIS.NET Class Library DataMapper V1.6.1, DataAccess V1.9.1

DbProvider.UseParameterPrefixInSql Property

Does this ConnectionProvider require the use of a Named Prefix in the SQL statement.

[Visual Basic]
<XmlAttribute(Type:=null, AttributeName:="useParameterPrefixInSql", Namespace:="null", Form:=XmlSchemaForm.None, TypeId:=System.Xml.Serialization.XmlAttributeAttribute)>
NotOverridable Public Property UseParameterPrefixInSql As  _
    Implements IDbProvider.
[C#]
[XmlAttribute(Type=null, AttributeName="useParameterPrefixInSql", Namespace="null", Form=XmlSchemaForm.None, TypeId=System.Xml.Serialization.XmlAttributeAttribute)]
public Boolean UseParameterPrefixInSql {get; set;}

Implements

IDbProvider.

Remarks

The OLE DB/ODBC .NET Provider does not support named parameters for passing parameters to an SQL Statement or a stored procedure called by an IDbCommand when CommandType is set to Text. For example, SqlClient requires select * from simple where simple_id = @simple_id If this is false, like with the OleDb or Obdc provider, then it is assumed that the ? can be a placeholder for the parameter in the SQL statement when CommandType is set to Text.

See Also

DbProvider Class | IBatisNet.Common Namespace