public Clause ColumnEquals(string column, SQLScriptParam param)
{
if (param == null)
{
throw new ArgumentNullException("param");
}
CheckColumnName(column);
return(new Clause(_accessor, string.Format("{0} = {1}", ConvertColumn(column), param.CoveredName),
new KeyValuePair <string, object>[] { param.ToKeyValuePair() }));
}
public Clause ColumnBetween(string column, SQLScriptParam param1, SQLScriptParam param2)
{
if (param1 == null)
{
throw new ArgumentNullException("param1");
}
if (param2 == null)
{
throw new ArgumentNullException("param2");
}
CheckColumnName(column);
return(new Clause(_accessor, string.Format("{0} BETWEEN {1} AND {2}", ConvertColumn(column), param1.CoveredName, param2.CoveredName),
new KeyValuePair <string, object>[] { param1.ToKeyValuePair(), param2.ToKeyValuePair() }));
}
public JoinItem ON(string column, SQLScriptParam param)
{
if (string.IsNullOrWhiteSpace(column))
{
throw new ArgumentNullException("column");
}
if (param == null)
{
throw new ArgumentNullException("param");
}
if (!this.Columns.Any(c => c.Key.Equals(column.Trim().ToUpper())))
{
throw new ApplicationException(string.Format("Column({0}) is not in table({1})", column, this.TableName));
}
var key = this.Columns.First(c => c.Key.Equals(column.Trim().ToUpper())).Value;
var clause = new Clause(_accessor, string.Format("{0} = {1}", key, param.CoveredName), new KeyValuePair <string, object>[] { param.ToKeyValuePair() });
return(ON(clause));
}