/// <summary>
/// Adds a new parameter expression object to the given collection of expressions.
/// </summary>
/// <typeparam name="TExpressionCollection">The destination expressions collection.</typeparam>
/// <param name="values">Destination expressions collection.</param>
/// <param name="paramName">The new parameter's name.</param>
/// <returns>The given destination expressions collection to enable fluent syntax.</returns>
public static TExpressionCollection Parameter <TExpressionCollection>(this TExpressionCollection values, string paramName)
where TExpressionCollection : ICollection <Sql.IExpression>
{
Sql.Parameter param = new Sql.Parameter(paramName);
values.Add(param);
return(values);
}
/// <summary>
/// Defines the values that compose the new record.
/// </summary>
/// <typeparam name="TInsertQuery">Type of INSERT statement.</typeparam>
/// <param name="insertQuery">The insert statement object to operate on.</param>
/// <param name="parameterNames">The parameter names used to create parameter expressions
/// that are used as values for the enumerated fields to be inserted.</param>
/// <returns>The given insert statement object to enable fluent syntax.</returns>
public static TInsertQuery Values <TInsertQuery>(this TInsertQuery insertQuery, params string[] parameterNames)
where TInsertQuery : Sql.SimpleInsertQuery
{
Sql.Parameter[] parameters = new Sql.Parameter[parameterNames.Length];
int i = 0;
foreach (string parameterName in parameterNames)
{
parameters[i++] = new Sql.Parameter(parameterName);
}
return(Values(insertQuery, parameters));
}
