Tortuga.Chain Namespace
Tortuga.Chain.Access Namespace
Tortuga.Chain.Aggregates Namespace
Tortuga.Chain.Appenders Namespace
Tortuga.Chain.AuditRules Namespace
Tortuga.Chain.CommandBuilders Namespace
Tortuga.Chain.Core Namespace
Tortuga.Chain.DataSources Namespace
Tortuga.Chain.Materializers Namespace
Tortuga.Chain.Metadata Namespace
Tortuga.Chain.MySql Namespace
Tortuga.Chain.MySql.CommandBuilders Namespace
Tortuga.Chain.PostgreSql Namespace
Tortuga.Chain.PostgreSql.CommandBuilders Namespace
Tortuga.Chain.SQLite Namespace
Tortuga.Chain.SqlServer Namespace
Tortuga.Chain.SqlServer.CommandBuilders Namespace

SqlBuilder<(Of <(<'TDbType>)>)>..::..BuildSelectTvpForInsertClause Method

Builds a list of columns suitable for using in a SELECT from @TableParameter clause.

Namespace:  Tortuga.Chain.CommandBuilders
Assembly:  Tortuga.Chain.Core (in Tortuga.Chain.Core.dll)

Syntax

public void BuildSelectTvpForInsertClause(
	StringBuilder sql,
	Nullable<string> header,
	Nullable<string> prefix,
	Nullable<string> footer,
	bool includeIdentityColumn
)
Public Sub BuildSelectTvpForInsertClause ( _
	sql As StringBuilder, _
	header As Nullable(Of String), _
	prefix As Nullable(Of String), _
	footer As Nullable(Of String), _
	includeIdentityColumn As Boolean _
)
public:
void BuildSelectTvpForInsertClause(
	StringBuilder^ sql, 
	Nullable<String^> header, 
	Nullable<String^> prefix, 
	Nullable<String^> footer, 
	bool^ includeIdentityColumn
)

Parameters

sql
Type: StringBuilder
The SQL being generated.
header
Type: Nullable<(Of <(<'String>)>)>
The optional header (e.g. "SELECT, OUTPUT).
prefix
Type: Nullable<(Of <(<'String>)>)>
An optional prefix for each column name.
footer
Type: Nullable<(Of <(<'String>)>)>
The optional footer.
includeIdentityColumn
Type: Boolean
Include the identity column. Used when performing an identity insert operation.

Remarks

If no columns are marked for reading, the header and footer won't be emitted.

See Also

SqlBuilder<(Of <(<'TDbType>)>)> Class
Tortuga.Chain.CommandBuilders Namespace