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