Table of Contents

Class CLRAssemblySchema.Assembly

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

sys.assemblies (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Managed Instance √ Azure Synapse Analytics √ Analytics Platform System (PDW)

Returns a row for each assembly.


See sys.assemblies.

[Table(Schema = "sys", Name = "assemblies", IsView = true)]
public class CLRAssemblySchema.Assembly
Inheritance
CLRAssemblySchema.Assembly
Extension Methods

Properties

AssemblyID

Assembly identification number. Is unique within a database.

[Column("assembly_id")]
[NotNull]
public int AssemblyID { get; set; }

Property Value

int

ClrName

Canonical string that encodes the simple name, version number, culture, public key, and architecture of the assembly. This value uniquely identifies the assembly on the common language runtime (CLR) side.

[Column("clr_name")]
[Nullable]
public string? ClrName { get; set; }

Property Value

string

CreateDate

Date the assembly was created or registered.

[Column("create_date")]
[NotNull]
public DateTime CreateDate { get; set; }

Property Value

DateTime

IsUserDefined

Indicates the source of the assembly.

0 = System-defined assemblies (such as Microsoft.SqlServer.Types for the hierarchyid data type)

1 = User-defined assemblies

[Column("is_user_defined")]
[Nullable]
public bool? IsUserDefined { get; set; }

Property Value

bool?

IsVisible

1 = Assembly is visible to register Transact-SQL entry points.

0 = Assembly is intended only for managed callers. That is, the assembly provides internal implementation for other assemblies in the database.

[Column("is_visible")]
[NotNull]
public bool IsVisible { get; set; }

Property Value

bool

ModifyDate

Date the assembly was modified.

[Column("modify_date")]
[NotNull]
public DateTime ModifyDate { get; set; }

Property Value

DateTime

Name

Name of the assembly. Is unique within the database.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

PermissionSet

Permission-set/security-level for assembly.

1 = Safe Access

2 = External Access

3 = Unsafe Access

[Column("permission_set")]
[Nullable]
public byte? PermissionSet { get; set; }

Property Value

byte?

PermissionSetDesc

Description for permission-set/security-level for assembly.

SAFE_ACCESS

EXTERNAL_ACCESS

UNSAFE_ACCESS

[Column("permission_set_desc")]
[Nullable]
public string? PermissionSetDesc { get; set; }

Property Value

string

PrincipalID

ID of the principal that owns this assembly.

[Column("principal_id")]
[Nullable]
public int? PrincipalID { get; set; }

Property Value

int?