Table of Contents

Class SecuritySchema.ColumnEncryptionKeyValue

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

sys.column_encryption_key_values (Transact-SQL)

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

Returns information about encrypted values of column encryption keys (CEKs) created with either the CREATE COLUMN ENCRYPTION KEY or the ALTER COLUMN ENCRYPTION KEY (Transact-SQL) statement. Each row represents a value of a CEK, encrypted with a column master key (CMK).


See sys.column_encryption_key_values.

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

Properties

ColumnEncryptionKeyID

ID of the CEK in the database.

[Column("column_encryption_key_id")]
[NotNull]
public int ColumnEncryptionKeyID { get; set; }

Property Value

int

ColumnMasteRKeyID

ID of the column master key that was used to encrypt the CEK value.

[Column("column_master_key_id")]
[NotNull]
public int ColumnMasteRKeyID { get; set; }

Property Value

int

EncryptedValue

CEK value encrypted with the CMK specified in column_master_key_id.

[Column("encrypted_value")]
[Nullable]
public byte[]? EncryptedValue { get; set; }

Property Value

byte[]

EncryptionAlgorithmName

Name of an algorithm used to encrypt the CEK value.

Name of the encryption algorithm used to encrypt the value. The algorithm for the system providers must be RSA_OAEP.

[Column("encryption_algorithm_name")]
[Nullable]
public string? EncryptionAlgorithmName { get; set; }

Property Value

string