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
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
KeyID
ID of the encrypted key.
[Column("key_id")]
[NotNull]
public int KeyID { get; set; }
Property Value
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[]