Table of Contents

Class FilestreamAndFileTableSchema.DataContext

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll
public class FilestreamAndFileTableSchema.DataContext
Inheritance
FilestreamAndFileTableSchema.DataContext
Extension Methods

Constructors

DataContext(IDataContext)

public DataContext(IDataContext dataContext)

Parameters

dataContext IDataContext

Properties

DatabaseFilestreamOptions

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.

public ITable<FilestreamAndFileTableSchema.DatabaseFilestreamOption> DatabaseFilestreamOptions { get; }

Property Value

ITable<FilestreamAndFileTableSchema.DatabaseFilestreamOption>

FileTableSystemDefinedObjects

sys.filetable_system_defined_objects (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Displays a list of the system-defined objects that are related to FileTables. Contains one row for each system-defined object.
When you create a FileTable, related objects such as constraints and indexes are created at the same time. You cannot alter or drop these objects; they disappear only when the FileTable itself is dropped.
For more information about FileTables, see FileTables (SQL Server).


See sys.filetable_system_defined_objects.

public ITable<FilestreamAndFileTableSchema.FileTableSystemDefinedObject> FileTableSystemDefinedObjects { get; }

Property Value

ITable<FilestreamAndFileTableSchema.FileTableSystemDefinedObject>

FileTables

sys.filetables (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns a row for each FileTable in SQL Server. For more information about FileTables, see FileTables (SQL Server).


See sys.filetables.

public ITable<FilestreamAndFileTableSchema.FileTable> FileTables { get; }

Property Value

ITable<FilestreamAndFileTableSchema.FileTable>