public SqlQueryWhere <T, TProp> Where <TProp>(Expression <Func <T, TProp> > expression, string tableAlias)
{
var col = $"[{tableAlias}].[{SqlQueryColumn.GetColumnName(expression)}]";
var where = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters);
_where = where;
return(where);
}
public SqlQueryWhere <T, TProp> Where <TProp>(Expression <Func <T, TProp> > expression)
{
var aliasClause = !string.IsNullOrEmpty(Alias) ? $"[{Alias}]." : "";
var col = $"{aliasClause}[{SqlQueryColumn.GetColumnName(expression)}]";
var where = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters);
_where = where;
return(where);
}
public SqlQueryWhere <T, TProp> Where <TProp>(string columnName, string tableAlias)
{
var where = new SqlQueryWhere <T, TProp>(this, $"[{tableAlias}].[{columnName}]", _queryBuilder.Parameters);
_where = where;
return(where);
}
