Table of Contents

Class SecuritySchema.CryptProperty

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

sys.crypt_properties (Transact-SQL)

Applies to: √ SQL Server (all supported versions) √ Azure SQL Database

Returns one row for each cryptographic property associated with a securable.


See sys.crypt_properties.

[Table(Schema = "sys", Name = "crypt_properties", IsView = true)]
public class SecuritySchema.CryptProperty
Inheritance
SecuritySchema.CryptProperty
Extension Methods

Properties

Class

Identifies class of thing on which property exists.

1 = Object or column
5 = Assembly

[Column("class")]
[NotNull]
public byte Class { get; set; }

Property Value

byte

ClassDesc

Description of the class of thing on which property exists.

OBJECT_OR_COLUMN
ASSEMBLY

[Column("class_desc")]
[Nullable]
public string? ClassDesc { get; set; }

Property Value

string

CryptPropertyColumn

Signed or encrypted bits. For a signed module these are the signature bits of the module.

[Column("crypt_property")]
[NotNull]
public byte[] CryptPropertyColumn { get; set; }

Property Value

byte[]

CryptType

Encryption type.

SPVC = Signed by certificate private key

SPVA = Signed by asymmetric private key

CPVC = Counter signature by certificate private key

CPVA = Counter signature by asymmetric key

[Column("crypt_type")]
[NotNull]
public string CryptType { get; set; }

Property Value

string

CryptTypeDesc

Description of encryption type.

SIGNATURE BY CERTIFICATE

SIGNATURE BY ASYMMETRIC KEY

COUNTER SIGNATURE BY CERTIFICATE

COUNTER SIGNATURE BY ASYMMETRIC KEY

[Column("crypt_type_desc")]
[Nullable]
public string? CryptTypeDesc { get; set; }

Property Value

string

MajorID

ID of thing on which property exists, interpreted according to class

[Column("major_id")]
[NotNull]
public int MajorID { get; set; }

Property Value

int

Thumbprint

SHA-1 hash of the certificate or asymmetric key used.

[Column("thumbprint")]
[NotNull]
public byte[] Thumbprint { get; set; }

Property Value

byte[]