Class FilestreamAndFileTableSchema.DatabaseFilestreamOption

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.database_filestream_options (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Displays information about the level of non-transactional access to FILESTREAM data in FileTables that is enabled. Contains one row for each database in the SQL Server instance.
For more information about FileTables, see FileTables (SQL Server).

See sys.database_filestream_options.

[Table(Schema = "sys", Name = "database_filestream_options", IsView = true)]
public class FilestreamAndFileTableSchema.DatabaseFilestreamOption

Inheritance

object

FilestreamAndFileTableSchema.DatabaseFilestreamOption

Extension Methods

Map.DeepCopy<T>(T)

Properties

DatabaseID

The ID of the database. This value is unique within the SQL Server instance.

[Column("database_id")]
[NotNull]
public int DatabaseID { get; set; }

Property Value

int

DirectoryName

The database-level directory for all FileTable namespaces.

[Column("directory_name")]
[Nullable]
public string? DirectoryName { get; set; }

Property Value

string

NonTransactedAccess

The level of non-transactional access to FILESTREAM data that is enabled. The level of access is set by the NON_TRANSACTED_ACCESS option of the CREATE DATABASE or ALTER DATABASE statement.

This setting has one of the following values:

0 - Not enabled. This is the default value. This level is set by providing the value OFF for the NON_TRANSACTED_ACCESS option.

1 - Read-only access. This level is set by providing the value READ_ONLY for the NON_TRANSACTED_ACCESS option.

3 - Full access. This level is set by providing the value FULL for the NON_TRANSACTED_ACCESS option.

5 - In transition to READONLY

6 - In transition to OFF

[Column("non_transacted_access")]
[NotNull]
public byte NonTransactedAccess { get; set; }

Property Value

byte

NonTransactedAccessDesc

The description of the level of non-transactional access identified in non_transacted_access.

This setting has one of the following values:

NONE - This is the default value.

READ_ONLY

FULL

IN_TRANSITION_TO_READ_ONLY

IN_TRANSITION_TO_OFF

[Column("non_transacted_access_desc")]
[NotNull]
public string NonTransactedAccessDesc { get; set; }

Property Value

string