Table of Contents

Class DataTierApplicationsSchema.Instance

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

Data-tier Application Views - dbo.sysdac_instances

Applies to: √ SQL Server (all supported versions)

Displays one row for each data-tier application (DAC) instance deployed to an instance of the Database Engine. sysdac_instances belongs to the dbo schema in the msdb database. The following table describes the columns in the sysdac_instances view.


See dbo.sysdac_instances.

[Table(Database = "msdb", Schema = "dbo", Name = "sysdac_instances", IsView = true)]
public class DataTierApplicationsSchema.Instance
Inheritance
DataTierApplicationsSchema.Instance
Extension Methods

Properties

CreatedBy

Login that created the DAC instance.

[Column("created_by")]
[NotNull]
public string CreatedBy { get; set; }

Property Value

string

DatabaseName

Name of the database created for the DAC isntance.

[Column("database_name")]
[NotNull]
public string DatabaseName { get; set; }

Property Value

string

DateCreated

Date and time the DAC instance was created.

[Column("date_created")]
[NotNull]
public DateTime DateCreated { get; set; }

Property Value

DateTime

Description

A description of the DAC written when the DAC package was created.

[Column("description")]
[NotNull]
public string Description { get; set; }

Property Value

string

InstanceID

Identifier of the DAC instance.

[Column("instance_id")]
[NotNull]
public Guid InstanceID { get; set; }

Property Value

Guid

InstanceName

Name of the DAC instance specified when the DAC was deployed.

[Column("instance_name")]
[NotNull]
public string InstanceName { get; set; }

Property Value

string

TypeName

Name of the DAC specified when the DAC package was created.

[Column("type_name")]
[NotNull]
public string TypeName { get; set; }

Property Value

string

TypeStream

A bit stream that contains an encoded representation of the logical objects, such as tables and views, contained in the DAC.

[Column("type_stream")]
[NotNull]
public byte[] TypeStream { get; set; }

Property Value

byte[]

TypeVersion

Version of the DAC specified when the DAC package was created.

[Column("type_version")]
[NotNull]
public string TypeVersion { get; set; }

Property Value

string