Table of Contents

Class SecuritySchema.KeyEncryption

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

sys.key_encryptions (Transact-SQL)

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

Returns a row for each symmetric key encryption specified by using the ENCRYPTION BY clause of the CREATE SYMMETRIC KEY statement.


See sys.key_encryptions.

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

Properties

CryptProperty

Signed or encrypted bits.

[Column("crypt_property")]
[Nullable]
public byte[]? CryptProperty { get; set; }

Property Value

byte[]

CryptType

Type of encryption:

ESKS = Encrypted by symmetric key

ESKP, ESP2, or ESP3 = Encrypted by password

EPUC = Encrypted by certificate

EPUA = Encrypted by asymmetric key

ESKM = Encrypted by master key

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

Property Value

string

CryptTypeDesc

Description of encryption type:

ENCRYPTION BY SYMMETRIC KEY

ENCRYPTION BY PASSWORD
(Beginning with SQL Server 2017 (14.x), includes a version number for use by CSS.)

ENCRYPTION BY CERTIFICATE

ENCRYPTION BY ASYMMETRIC KEY

ENCRYPTION BY MASTER KEY

Note: Windows DPAPI is used to protect the service master key.

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

Property Value

string

KeyID

ID of the encrypted key.

[Column("key_id")]
[NotNull]
public int KeyID { get; set; }

Property Value

int

Thumbprint

SHA-1 hash of the certificate with which the key is encrypted, or the GUID of the symmetric key with which the key is encrypted.

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

Property Value

byte[]