public SqlQueryWhere <T, TProp> AndWhere <TProp>(string columnName)
{
var andWhere = new SqlQueryWhere <T, TProp>(this, $"[{columnName}]", _queryBuilder.Parameters);
_ands.Add(andWhere);
return(andWhere);
}
public SqlQueryWhere <T, TProp> OrWhere <TProp>(string columnName, string tableAlias)
{
var orWhere = new SqlQueryWhere <T, TProp>(this, $"[{tableAlias}].[{columnName}]", _queryBuilder.Parameters);
_ors.Add(orWhere);
return(orWhere);
}
public SqlQueryWhere <T, TProp> AndWhere <TProp>(Expression <Func <T, TProp> > expression, string tableAlias)
{
var col = $"[{tableAlias}].[{SqlQueryColumn.GetColumnName(expression)}]";
var andWhere = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters);
_ands.Add(andWhere);
return(andWhere);
}
public SqlQueryWhere <T, TProp> AndWhere <TProp>(Expression <Func <T, TProp> > expression)
{
var aliasClause = !string.IsNullOrEmpty(Alias) ? $"[{Alias}]." : "";
var col = $"{aliasClause}[{SqlQueryColumn.GetColumnName(expression)}]";
var andWhere = new SqlQueryWhere <T, TProp>(this, col, _queryBuilder.Parameters);
_ands.Add(andWhere);
return(andWhere);
}
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);
}
