/// <summary> /// Create a 'INSERT' command. /// </summary> /// <param name="tableDef">Table definition.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlInsertCommand(APTableDef tableDef, APSqlSelectCommand subQuery, params APSqlSelectPhrase[] phrases) { if (tableDef == null) throw new ArgumentNullException("tableDef"); _tableDef = tableDef; _subQuery = subQuery; _selectClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a 'INSERT' command. /// </summary> /// <param name="tableDef">Table definition.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="clause">The 'SELECT' clause.</param> public APSqlInsertCommand(APTableDef tableDef, APSqlSelectCommand subQuery, APSqlSelectClause clause) { if (tableDef == null) throw new ArgumentNullException("tableDef"); _tableDef = tableDef; _subQuery = subQuery; _selectClause = clause; }
/// <summary> /// Create a 'INSERT' command. /// </summary> /// <param name="tableDef">Table definition.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlInsertCommand(APTableDef tableDef, APSqlSelectCommand subQuery, IEnumerable <APSqlSelectPhrase> phrases) { if (tableDef == null) { throw new ArgumentNullException("tableDef"); } _tableDef = tableDef; _subQuery = subQuery; _selectClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a 'INSERT' command. /// </summary> /// <param name="tableDef">Table definition.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="clause">The 'SELECT' clause.</param> public APSqlInsertCommand(APTableDef tableDef, APSqlSelectCommand subQuery, APSqlSelectClause clause) { if (tableDef == null) { throw new ArgumentNullException("tableDef"); } _tableDef = tableDef; _subQuery = subQuery; _selectClause = clause; }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrases. /// </summary> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlSelectCommand(IEnumerable<APSqlSelectPhrase> phrases) { _selectExprClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrases. /// </summary> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlSelectCommand(params APSqlSelectPhrase[] phrases) { _selectExprClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrase. /// </summary> /// <param name="phrase">The 'SELECT' phrase.</param> public APSqlSelectCommand(APSqlSelectPhrase phrase) { _selectExprClause = new APSqlSelectClause(phrase); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' clause. /// </summary> /// <param name="clause">The 'SELECT' clause.</param> public APSqlSelectCommand(APSqlSelectClause clause) { _selectExprClause = clause; }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' clause. /// </summary> /// <param name="clause">The 'SELECT' clause.</param> /// <returns>The command.</returns> public static APSqlSelectCommand select(APSqlSelectClause clause) { return new APSqlSelectCommand(clause); }
/// <summary> /// SQL SubQuery clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="clause">The 'SELECT' clause.</param> /// <returns>The command.</returns> public static APSqlInsertCommand subQuery(this APSqlInsertCommand command, APSqlSelectCommand subQuery, APSqlSelectClause clause) { command.SubQuery = subQuery; command.SelectClause = clause; return(command); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrases. /// </summary> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlSelectCommand(IEnumerable <APSqlSelectPhrase> phrases) { _selectExprClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrases. /// </summary> /// <param name="phrases">The 'SELECT' phrases.</param> public APSqlSelectCommand(params APSqlSelectPhrase[] phrases) { _selectExprClause = new APSqlSelectClause(phrases); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' phrase. /// </summary> /// <param name="phrase">The 'SELECT' phrase.</param> public APSqlSelectCommand(APSqlSelectPhrase phrase) { _selectExprClause = new APSqlSelectClause(phrase); }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' clause. /// </summary> /// <param name="clause">The 'SELECT' clause.</param> public APSqlSelectCommand(APSqlSelectClause clause) { _selectExprClause = clause; }
/// <summary> /// SQL SubQuery clause extensions. /// </summary> /// <param name="command">The command.</param> /// <param name="subQuery">SubQuery.</param> /// <param name="clause">The 'SELECT' clause.</param> /// <returns>The command.</returns> public static APSqlInsertCommand subQuery(this APSqlInsertCommand command, APSqlSelectCommand subQuery, APSqlSelectClause clause) { command.SubQuery = subQuery; command.SelectClause = clause; return command; }
/// <summary> /// Create a new 'SELECT' command with 'SELECT' clause. /// </summary> /// <param name="clause">The 'SELECT' clause.</param> /// <returns>The command.</returns> public static APSqlSelectCommand select(APSqlSelectClause clause) { return(new APSqlSelectCommand(clause)); }