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" ); }