Class SecuritySchema.ColumnEncryptionKeyValue

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.column_encryption_key_values (Transact-SQL)

Applies to: √ SQL Server √ Azure SQL Database √ Azure SQL Managed Instance

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

object

SecuritySchema.ColumnEncryptionKeyValue

Inherited Members

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

Extension Methods

Map.DeepCopy<T>(T)

Properties

ColumnEncryptionKeyID

column_encryption_key_id NOT NULL int

ID of the CEK in the database.

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

Property Value

int

ColumnMasteRKeyID

column_master_key_id NOT NULL int

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

encrypted_value NULL varbinary(8000)

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

encryption_algorithm_name NULL sysname

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