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