/// <summary> /// Creates a new condition. /// </summary> /// <param name="table">The column's table name.</param> /// <param name="column">The column name.</param> /// <param name="query">The query for the condition.</param> /// <returns> /// A new condition. /// </returns> public static Condition NotIn(string table, string column, Select query) => new Condition(OperationType.NotIn, new Column(table, column), query);
// With string column name
/// <summary>
/// Creates a new condition.
/// </summary>
/// <param name="column">The column name.</param>
/// <param name="query">The query for the condition.</param>
/// <returns>
/// A new condition.
/// </returns>
public static Condition In(string column, Select query)
=> new Condition(OperationType.In, new Column(column), query);
/// <summary> /// Creates a new condition. /// </summary> /// <param name="column">The column for the condition.</param> /// <param name="query">The query for the condition.</param> /// <returns> /// A new condition. /// </returns> public static Condition NotIn(ISqlElement column, Select query) => new Condition(OperationType.NotIn, column, query);
/// <summary> /// Creates a new condition. /// </summary> /// <param name="columns">The column for the condition.</param> /// <param name="query">The query for the condition.</param> /// <returns> /// A new condition. /// </returns> public static Condition NotIn(IEnumerable <Column> columns, Select query) => new Condition(OperationType.NotIn, new Columns(columns), query);
/// <summary> /// Creates a new condition. /// </summary> /// <param name="query">The query for the condition.</param> /// <returns> /// A new condition. /// </returns> public static Condition NotExists(Select query) => new Condition(OperationType.NotExists, query, null);