public override SqlStringBuilder Where(AssignValue filter)
{
WhereFormat where = OracleFormatProvider.GetWhereFormat(filter, StringBuilder, NextNumber);
NextNumber = where.NextNumber;
this.parameters.AddRange(where.Parameters);
return(this);
}
public virtual SqlStringBuilder Where(dynamic parameters)
{
IEnumerable <AssignValue> values = AssignValue.FromDynamic(parameters, ColumnNameFormatter);
foreach (AssignValue value in values)
{
this.Where(value);
}
return(this);
}
public virtual SqlStringBuilder Where(AssignValue filter)
{
WhereFormat where = new WhereFormat();
where.ColumnNameFormatter = filter.ColumnNameFormatter;
where.StartNumber = NextNumber;
where.AddAssignment(filter);
_stringBuilder.Append(where.Parse());
NextNumber = where.NextNumber;
this.parameters.AddRange(where.Parameters);
return(this);
}
public void AddAssignment(AssignValue value)
{
this.AddParameter(value);
}
public virtual SqlStringBuilder Insert(string tableName, dynamic valueAssignments)
{
IEnumerable <AssignValue> values = AssignValue.FromDynamic(valueAssignments, ColumnNameFormatter);
return(Insert(tableName, values.ToArray()));
}
public virtual SqlStringBuilder Update(string tableName, Dictionary <string, object> valueAssignments)
{
IEnumerable <AssignValue> values = AssignValue.FromDictionary <string, object>(valueAssignments, ColumnNameFormatter);
return(Update(tableName, values.ToArray()));
}