public MsSqlCondition(string expression, string @operator, object value, MsSqlQueryStatementBase parent)
: base(parent)
{
Expression = expression;
Operator = @operator;
Value = value;
}
public MsSqlJoin(string joinType, string joinSource, string joinCondition, MsSqlQueryStatementBase parent)
: base(parent)
{
JoinType = joinType ?? throw new ArgumentNullException(nameof(joinType));
JoinSource = joinSource ?? throw new ArgumentNullException(nameof(joinSource));
JoinCondition = joinCondition ?? throw new ArgumentNullException(nameof(joinCondition));
}
private static string AndOrWhere(MsSqlQueryStatementBase statement, string valueIfNoWhere)
{
if (statement == null)
{
throw new ArgumentNullException(nameof(statement));
}
var current = statement;
while (current != null)
{
if (current is IWhere && !current.Include)
{
return(MsSql.Where);
}
current = current.Parent;
}
return(valueIfNoWhere);
}
public MsSqlScope(MsSqlQueryStatementBase scopedQuery) : base(null)
{
_scopedQuery = scopedQuery ?? throw new ArgumentNullException(nameof(scopedQuery));
}
public MsSqlWhere(MsSqlQueryStatementBase query, MsSqlQueryStatementBase parent)
: base(parent)
{
SubQuery = query ?? throw new ArgumentNullException(nameof(query));
}
internal static MsSqlWhere WhereAll(MsSqlQueryStatementBase parent, params string[] expressions)
{
return(new MsSqlWhere(OrAnyHelpers.All(expressions), parent));
}
public IWhere Where(MsSqlQueryStatementBase query)
{
return(new MsSqlWhere(query, this));
}
public MsSqlFrom(string expression, MsSqlQueryStatementBase parent)
: base(parent)
{
Expression = expression;
}
public MsSqlOrderBy(string expression, string sorting, MsSqlQueryStatementBase parent)
: base(parent)
{
Expression = expression ?? throw new ArgumentNullException(nameof(expression));
Sorting = sorting;
}
public MsSqlSelector(MsSqlQueryStatementBase parent)
: this(MsSql.AllColumns, parent)
{
}
public MsSqlSelector(string expression, MsSqlQueryStatementBase parent)
: base(parent)
{
Expression = expression ?? throw new ArgumentNullException(nameof(expression));
}
public MsSqlCondition(string expression, object value, MsSqlQueryStatementBase parent)
: this(expression, Operators.Equal, value, parent)
{
}
public MsSqlCondition(string expression, MsSqlQueryStatementBase parent)
: this(expression, null, null, parent)
{
}
public MsSqlAnd(MsSqlQueryStatementBase subQuery, MsSqlQueryStatementBase parent)
: base(parent)
{
SubQuery = subQuery ?? throw new ArgumentNullException(nameof(subQuery));
}
internal static MsSqlAnd AndAny(MsSqlQueryStatementBase parent, params string[] expressions)
{
return(new MsSqlAnd(OrAnyHelpers.Any(expressions), parent));
}
protected MsSqlQueryStatementBase(MsSqlQueryStatementBase parent)
{
Parent = parent;
}