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); }