public void NoBooleanParameters()
{
OracleDataClientDriver driver = new OracleDataClientDriver();
SqlStringBuilder builder = new SqlStringBuilder();
builder.Add("select * from table1 where col1=");
builder.Add(Parameter.Placeholder);
IDbCommand cmd =
driver.GenerateCommand(CommandType.Text, builder.ToSqlString(), new SqlType[] {SqlTypeFactory.Boolean});
IDbDataParameter param = cmd.Parameters[0] as IDbDataParameter;
Assert.AreEqual("col1", param.ParameterName, "kept same param name");
Assert.IsFalse(param.DbType == DbType.Boolean, "should not still be a DbType.Boolean");
}
public void NoBooleanParameters()
{
Oracle9Dialect dialect = new Oracle9Dialect();
OracleDataClientDriver driver = new OracleDataClientDriver();
SqlStringBuilder builder = new SqlStringBuilder();
builder.Add( "select * from table1 where col1=");
builder.Add( new Parameter( "col1", new BooleanSqlType() ) );
IDbCommand cmd = driver.GenerateCommand( dialect, builder.ToSqlString() );
IDbDataParameter param = cmd.Parameters[0] as IDbDataParameter;
Assert.AreEqual( "col1", param.ParameterName , "kept same param name" );
Assert.IsFalse( param.DbType==DbType.Boolean, "should not still be a DbType.Boolean" );
}