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

IDbProvider.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)>
Property UseParameterPrefixInSql As 
[C#]
[XmlAttribute(Type=null, AttributeName="useParameterPrefixInSql", Namespace="null", Form=XmlSchemaForm.None, TypeId=System.Xml.Serialization.XmlAttributeAttribute)]
Boolean UseParameterPrefixInSql {get; set;}

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

IDbProvider Interface | IBatisNet.Common Namespace