public static Cond NotIn(Expr expr, List <Constant> values)
{
Cond oper = new Cond();
OmConstantCollection col = new OmConstantCollection();
for (int i = 0; i < values.Count; i++)
{
col.Add(values[i].Const);
}
oper.Term = WhereTerm.CreateNotIn(expr.Expression, col);
return(oper);
}
/// <summary>
/// Creates a WhereTerm which represents SQL IN clause
/// </summary>
/// <param name="expr">Expression to be looked up</param>
/// <param name="values">List of values</param>
/// <returns></returns>
static Cond In(Expr expr, List <Constant> values)
{
OmConstantCollection col = new OmConstantCollection();
for (int i = 0; i < values.Count; i++)
{
col.Add(values[i].Const.Value);
}
Cond term = new Cond();
term.Term = WhereTerm.CreateIn(expr.Expression, col);
return(term);
}