SqlCommandColumnEncryptionSetting SqlCommandColumnEncryptionSetting SqlCommandColumnEncryptionSetting SqlCommandColumnEncryptionSetting Enum

Definition

Specifies how data will be sent and received when reading and writing encrypted columns. Depending on your specific query, performance impact may be reduced by bypassing the Always Encrypted driver's processing when non-encrypted columns are being used. Note that these settings cannot be used to bypass encryption and gain access to plaintext data. For details, see Always Encrypted (Database Engine).

public enum class SqlCommandColumnEncryptionSetting
public enum SqlCommandColumnEncryptionSetting
type SqlCommandColumnEncryptionSetting = 
Public Enum SqlCommandColumnEncryptionSetting
Inheritance
SqlCommandColumnEncryptionSettingSqlCommandColumnEncryptionSettingSqlCommandColumnEncryptionSettingSqlCommandColumnEncryptionSetting

Fields

Disabled Disabled Disabled Disabled 3

Disables Always Encrypted for the query.

Enabled Enabled Enabled Enabled 1

Enables Always Encrypted for the query.

ResultSetOnly ResultSetOnly ResultSetOnly ResultSetOnly 2

Specifies that only the results of the command should be processed by the Always Encrypted routine in the driver. Use this value when the command has no parameters that require encryption.

UseConnectionSetting UseConnectionSetting UseConnectionSetting UseConnectionSetting 0

Specifies that the command should default to the Always Encrypted setting in the connection string.

Remarks

  • If Always Encrypted is disabled for a query and the query has parameters that need to be encrypted (parameters that correspond to encrypted columns), the query will fail.

  • If Always Encrypted is disabled for a query and the query returns results from encrypted columns, the query will return encrypted values. The encrypted values will have the varbinary datatype.

Applies to

See also