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