SqlCommandColumnEncryptionSetting Enum

Definition

Namespace:

Microsoft.Data.SqlClient

Assembly:

Microsoft.Data.SqlClient.dll

Package:

Microsoft.Data.SqlClient v5.2.0

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

Enum

SqlCommandColumnEncryptionSetting

Fields

Name	Value	Description
UseConnectionSetting	0	Specifies that the command should default to the Always Encrypted setting in the connection string.
Enabled	1	Enables Always Encrypted for the query.
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.
Disabled	3	Specifies the connection does not use Always Encrypted. Should be used if no queries sent over the connection access encrypted columns.

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.