public void TestParameterizedSql()
{
using (var reader = GeneralUtility.ExecuteReader("select * from RULES where RULE_ID = :1",
new object[] { -103 }))
{
Assert.IsNotNull(reader, "nothing returned!");
ReadFromReader(reader);
}
// a typical example from branch assignment:
const int esisAhsId = 202;
const string instance = "FNSBA";
const string lineOfBusiness = "CLI";
var sql = new StringBuilder("SELECT * FROM CLAIMNUMBERASSIGNMENTRULE ");
// parm :1 is int => NUMBER(10) =>DbType.Int32 N.B. strings do actually work OK but not recommended.
sql.Append("WHERE USEDUP_FLG='N' AND CLAIMNUMBERASSIGNMENTRULE.ACCNT_HRCY_STEP_ID = :1 ");
// parm :2 is string => VARCHAR => DbType.String N.B. no quotes required.
sql.Append("AND (CLAIMNUMBERASSIGNMENTRULE.LOB_CD = :2 OR CLAIMNUMBERASSIGNMENTRULE.LOB_CD='*')");
using (var reader = GeneralUtility.ExecuteReader(sql.ToString(), instance,
new object[] { esisAhsId, lineOfBusiness }))
{
Assert.IsNotNull(reader, "nothing returned!");
ReadFromReader(reader);
}
}