Class CreateTableOptions

Namespace

NextORM.Core

Assembly

nextorm.core.dll

Options for materialising a query into a table with TempTableExtensions. Providers that cannot express a given option reject it with NotSupportedException when the SQL is built.

public sealed record CreateTableOptions : IEquatable<CreateTableOptions>

Inheritance

object

CreateTableOptions

Implements

IEquatable<CreateTableOptions>

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Extension Methods

EntityBuilderExtensions.AsEntityBuilder<T>(object?)

Properties

Columns

The column names to declare on the created table, or null to derive them from the query. Not every provider accepts a column list together with AS SELECT (SQLite does not).

public IReadOnlyList<string>? Columns { get; init; }

Property Value

IReadOnlyList<string>

DropExisting

Whether an existing table with the target name is dropped first (DROP TABLE IF EXISTS), so the materialisation always reflects the current query. Only valid for a persistent table (see TempTableExtensions); mutually exclusive with IfNotExists. Defaults to false.

public bool DropExisting { get; init; }

Property Value

bool

IfNotExists

Whether the statement carries IF NOT EXISTS. Defaults to false.

public bool IfNotExists { get; init; }

Property Value

bool

OnCommit

The ON COMMIT action of a temporary table (PostgreSQL only). Only valid for a temporary table (see TempTableExtensions); defaults to PreserveRows.

public TempTableOnCommit OnCommit { get; init; }

Property Value

TempTableOnCommit

WithData

Whether the table is populated from the query; false renders WITH NO DATA (PostgreSQL only). Defaults to true.

public bool WithData { get; init; }

Property Value

bool