Пример #1
0
 /// <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);
Пример #2
0
        // 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);
Пример #3
0
 /// <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);
Пример #4
0
 /// <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);
Пример #5
0
 /// <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);