Enum TableOptions

Namespace

LinqToDB

Assembly

linq2db.dll

Provides table mapping flags to specify temporary table kind if mapped table is temporary table and Create/Drop Table API behavior when target table exists/not exists.

[Flags]
public enum TableOptions

Extension Methods

LinqExtensions.HasCreateIfNotExists(TableOptions)

LinqExtensions.HasDropIfExists(TableOptions)

LinqExtensions.HasIsGlobalTemporaryData(TableOptions)

LinqExtensions.HasIsGlobalTemporaryStructure(TableOptions)

LinqExtensions.HasIsLocalTemporaryData(TableOptions)

LinqExtensions.HasIsLocalTemporaryStructure(TableOptions)

LinqExtensions.HasIsTemporary(TableOptions)

LinqExtensions.HasIsTransactionTemporaryData(TableOptions)

LinqExtensions.IsSet(TableOptions)

LinqExtensions.IsTemporaryOptionSet(TableOptions)

LinqExtensions.Or(TableOptions, TableOptions)

Sql.Between<T>(T, T, T)

Sql.IsDistinctFrom<T>(T, T)

Sql.IsDistinctFrom<T>(T, T?)

Sql.IsNotDistinctFrom<T>(T, T)

Sql.IsNotDistinctFrom<T>(T, T?)

Sql.NotBetween<T>(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>)

Fields

CheckExistence = CreateIfNotExists | DropIfExists

CreateIfNotExists = 2

IF NOT EXISTS option of the CREATE statement. This option will have effect only for databases that support the option.

Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, Sybase ASE.

DropIfExists = 4

IF EXISTS option of the DROP statement. This option will have effect only for databases that support the option.

Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, Sybase ASE.

IsGlobalTemporaryData = 128

Table data is global temporary (table data is visible from other sessions). This option will have effect only for databases that support temporary tables.

Supported by: DB2, Firebird, Oracle, SAP Hana, SQL Server, Sybase ASE.

IsGlobalTemporaryStructure = 32

Table is global temporary (table structure is visible from other sessions). This option will have effect only for databases that support temporary tables.

Supported by: DB2, Firebird, Oracle, SAP Hana, SQL Server, Sybase ASE.

IsLocalTemporaryData = 64

Table data is temporary (table data is not visible to other sessions). This option will have effect only for databases that support temporary tables.

Supported by: DB2, Informix, MySql, PostgreSQL, SQLite, SAP Hana, SQL Server, Sybase ASE.

IsLocalTemporaryStructure = 16

Table is temporary (table structure is not visible to other sessions). This option will have effect only for databases that support temporary tables.

Supported by: DB2, Informix, MySql, PostgreSQL, SQLite, SAP Hana, SQL Server, Sybase ASE.

IsTemporary = 8

Table is temporary (not visible to other sessions). This option will have effect only for databases that support temporary tables. If database supports both global and local temporary tables, local table will be used.

Supported by: DB2, Firebird, Informix, MySql, Oracle, PostgreSQL, SQLite, SQL Server, SAP Hana, Sybase ASE.

IsTemporaryOptionSet = IsTemporary | IsLocalTemporaryStructure | IsGlobalTemporaryStructure | IsLocalTemporaryData | IsGlobalTemporaryData | IsTransactionTemporaryData

IsTransactionTemporaryData = 256

Table data is temporary (table data is transaction level visible). This option will have effect only for databases that support temporary tables.

Supported by: Firebird, Oracle, PostgreSQL.

None = 1

NotSet = 0