SqlBuilder<(Of <(<'TDbType>)>)>..::..BuildValuesClause<(Of <(<'TParameter>)>)> Method (StringBuilder, String, String, Boolean, String, List<(Of <(<'TParameter>)>)>, ParameterBuilderCallback<(Of <(<'TParameter, TDbType>)>)>)
Builds a list of columns suitable for using in the VALUES clause of INSERT statement. This does not include the actual VALUES keyword.
This will add the associated parameters to the parameters collection.
Namespace:
Tortuga.Chain.CommandBuildersAssembly: Tortuga.Chain.Core (in Tortuga.Chain.Core.dll)
Syntax
public void BuildValuesClause<TParameter>( StringBuilder sql, string header, string footer, bool includeIdentityColumn, string parameterSuffix, List<TParameter> parameters, ParameterBuilderCallback<TParameter, TDbType> parameterBuilder ) where TParameter : DbParameter
Public Sub BuildValuesClause(Of TParameter As DbParameter) ( _ sql As StringBuilder, _ header As String, _ footer As String, _ includeIdentityColumn As Boolean, _ parameterSuffix As String, _ parameters As List(Of TParameter), _ parameterBuilder As ParameterBuilderCallback(Of TParameter, TDbType) _ )
public: generic<typename TParameter> where TParameter : DbParameter void BuildValuesClause( StringBuilder^ sql, String^ header, String^ footer, bool^ includeIdentityColumn, String^ parameterSuffix, List<TParameter>^ parameters, ParameterBuilderCallback<TParameter, TDbType>^ parameterBuilder )
Type Parameters
- TParameter
- The type of the t parameter.
Parameters
- sql
- Type: StringBuilder
The SQL being generated.
- header
- Type: String
The optional header. Usually "VALUES (".
- footer
- Type: String
The optional footer. Usually just ")".
- includeIdentityColumn
- Type: Boolean
Include the identity column. Used when performing an identity insert operation.
- parameterSuffix
- Type: String
The parameter suffix. Must be unique for each row.
- parameters
- Type: List<(Of <(<'TParameter>)>)>
The parameter list to be updated.
- parameterBuilder
- Type: Tortuga.Chain.CommandBuilders..::..ParameterBuilderCallback<(Of <(<'TParameter, TDbType>)>)>
The parameter builder.