Class CreateTableOptions

Namespace

LinqToDB

Assembly

linq2db.dll

Options for creating a table.

public record CreateTableOptions : IEquatable<CreateTableOptions>

Inheritance

object

CreateTableOptions

Implements

IEquatable<CreateTableOptions>

Derived

CreateTempTableOptions

Extension Methods

Utils.IsNullValue(object?)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T)

SqlExtensions.In<T>(T, T, T)

SqlExtensions.In<T>(T, T, T, T)

SqlExtensions.In<T>(T, params T[])

SqlExtensions.In<T>(T, IEnumerable<T>)

SqlExtensions.In<T>(T, IQueryable<T>)

SqlExtensions.NotIn<T>(T, T, T)

SqlExtensions.NotIn<T>(T, T, T, T)

SqlExtensions.NotIn<T>(T, params T[])

SqlExtensions.NotIn<T>(T, IEnumerable<T>)

SqlExtensions.NotIn<T>(T, IQueryable<T>)

Constructors

CreateTableOptions(string?, string?, string?, string?, string?, string?, TableOptions, DefaultNullable)

Options for creating a table.

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

Parameters

TableName string

Optional name of 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 None.

DefaultNullable DefaultNullable

Defines how columns nullability flag should be generated:

- Null - generate only NOT NULL for non-nullable fields. Missing nullability information treated as NULL by database.

- NotNull - generate only NULL for nullable fields. Missing nullability information treated as NOT NULL by database.

- None - explicitly generate NULL and NOT NULL for all columns.

Default value: None.

Properties

DatabaseName

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

public string? DatabaseName { get; init; }

Property Value

string

DefaultNullable

Defines how columns nullability flag should be generated:

- Null - generate only NOT NULL for non-nullable fields. Missing nullability information treated as NULL by database.

- NotNull - generate only NULL for nullable fields. Missing nullability information treated as NOT NULL by database.

- None - explicitly generate NULL and NOT NULL for all columns.

Default value: None.

public DefaultNullable DefaultNullable { get; init; }

Property Value

DefaultNullable

SchemaName

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

public string? SchemaName { get; init; }

Property Value

string

ServerName

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

public string? ServerName { get; init; }

Property Value

string

StatementFooter

SQL appended to the generated create table statement.

public string? StatementFooter { get; init; }

Property Value

string

StatementHeader

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

public string? StatementHeader { get; init; }

Property Value

string

TableName

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

public string? TableName { get; init; }

Property Value

string

TableOptions

Optional Table options. Default is None.

public TableOptions TableOptions { get; init; }

Property Value

TableOptions