Search Results for

    Show / Hide Table of Contents

    Enum TableOptions

    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.

    Namespace: LinqToDB
    Assembly: linq2db.dll
    Syntax
    public enum TableOptions : int

    Fields

    Name Description
    CheckExistence
    CreateIfNotExists

    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

    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

    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

    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

    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

    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

    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
    IsTransactionTemporaryData

    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
    NotSet

    Extension Methods

    Map.DeepCopy<TableOptions>()
    LinqExtensions.IsSet()
    LinqExtensions.IsTemporaryOptionSet()
    LinqExtensions.HasCreateIfNotExists()
    LinqExtensions.HasDropIfExists()
    LinqExtensions.HasIsTemporary()
    LinqExtensions.HasIsLocalTemporaryStructure()
    LinqExtensions.HasIsGlobalTemporaryStructure()
    LinqExtensions.HasIsLocalTemporaryData()
    LinqExtensions.HasIsGlobalTemporaryData()
    LinqExtensions.HasIsTransactionTemporaryData()
    LinqExtensions.Or(TableOptions)
    Sql.IsDistinctFrom<TableOptions>(TableOptions)
    Sql.IsDistinctFrom<TableOptions>(Nullable<TableOptions>)
    Sql.IsNotDistinctFrom<TableOptions>(TableOptions)
    Sql.IsNotDistinctFrom<TableOptions>(Nullable<TableOptions>)
    SqlExtensions.In<TableOptions>(IEnumerable<TableOptions>)
    SqlExtensions.In<TableOptions>(IQueryable<TableOptions>)
    SqlExtensions.In<TableOptions>(TableOptions[])
    SqlExtensions.In<TableOptions>(TableOptions, TableOptions)
    SqlExtensions.In<TableOptions>(TableOptions, TableOptions, TableOptions)
    SqlExtensions.NotIn<TableOptions>(IEnumerable<TableOptions>)
    SqlExtensions.NotIn<TableOptions>(IQueryable<TableOptions>)
    SqlExtensions.NotIn<TableOptions>(TableOptions[])
    SqlExtensions.NotIn<TableOptions>(TableOptions, TableOptions)
    SqlExtensions.NotIn<TableOptions>(TableOptions, TableOptions, TableOptions)
    • Improve this Doc
    • View Source
    In This Article
    Back to top Copyright © 2011-2022 linq2db.com

    Generated by DocFX