Table of Contents

Class CreateTempTableOptions

Namespace
LinqToDB
Assembly
linq2db.dll

Options for creating a temporary table.

public sealed record CreateTempTableOptions : CreateTableOptions, IEquatable<CreateTableOptions>, IEquatable<CreateTempTableOptions>
Inheritance
object
CreateTempTableOptions
Implements
Inherited Members
Extension Methods

Constructors

CreateTempTableOptions(string?, string?, string?, string?, string?, string?, TableOptions, DefaultNullable)

Options for creating a temporary table.

public CreateTempTableOptions(string? TableName = null, string? DatabaseName = null, string? SchemaName = null, string? ServerName = null, string? StatementHeader = null, string? StatementFooter = null, TableOptions TableOptions = TableOptions.IsTemporary, DefaultNullable DefaultNullable = DefaultNullable.None)

Parameters

TableName string

Optional name of temporary table. If not specified, value from mapping will be used.

DatabaseName string

Optional name of table's database. If not specified, value from mapping will be used.

SchemaName string

Optional name of table schema/owner. If not specified, value from mapping will be used.

ServerName string

Optional name of linked server. If not specified, value from mapping will be used.

StatementHeader string

Replacement for "CREATE TABLE table_name" header. Header is a template with {0} parameter for table name.

StatementFooter string

SQL appended to the generated create table statement.

TableOptions TableOptions

Optional Table options. Default is IsTemporary.

DefaultNullable DefaultNullable

Defines how columns nullability flag should be generated:

<p> - <xref href="LinqToDB.SqlQuery.DefaultNullable.Null" data-throw-if-not-resolved="false"></xref> - generate only <code>NOT NULL</code> for non-nullable fields. Missing nullability information treated as <code>NULL</code> by database.</p>
<p> - <xref href="LinqToDB.SqlQuery.DefaultNullable.NotNull" data-throw-if-not-resolved="false"></xref> - generate only <code>NULL</code> for nullable fields. Missing nullability information treated as <code>NOT NULL</code> by database.</p>
<p> - <xref href="LinqToDB.SqlQuery.DefaultNullable.None" data-throw-if-not-resolved="false"></xref> - explicitly generate <code>NULL</code> and <code>NOT NULL</code> for all columns.</p>

Default value: <xref href="LinqToDB.SqlQuery.DefaultNullable.None" data-throw-if-not-resolved="false"></xref>.