public SprySelectColumn <TDto> Column <TProperty>(Expression <Func <TDto, TProperty> > columnExpression, string colPrefix)
{
var columnName = SpryExpression.GetColumnName(columnExpression);
AppendColumn(colPrefix + "." + columnName);
return(this);
}
public UpdateValue <TDto> Set <TProperty>(Expression <Func <TDto, TProperty> > valueExpression)
{
var columnName = SpryExpression.GetColumnName(valueExpression);
var value = SpryExpression.GetColumnValue(valueExpression);
SetValueImpl(columnName, value);
return(this);
}
public Where <TDto, TProperty, TTable> Where <TProperty>(Expression <Func <TDto, TProperty> > columnExpression, string colPrefix = null)
{
var columnName = SpryExpression.GetColumnName(columnExpression);
if (!string.IsNullOrWhiteSpace(colPrefix))
{
columnName = colPrefix + "." + columnName;
}
var where = new Where <TDto, TProperty, TTable>(TableImpl, Parameters, columnName);
WhereCondition = where;
return(where);
}
public InsertValue <TDto> OutputInserted <TProperty>(Expression <Func <TDto, TProperty> > columnExpression)
{
_outputCol = SpryExpression.GetColumnName(columnExpression);
return(this);
}
