SqlCommandColumnEncryptionSetting Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 SqlCommandColumnEncryptionSettingpublic enum SqlCommandColumnEncryptionSettingtype SqlCommandColumnEncryptionSetting = Public Enum SqlCommandColumnEncryptionSetting- Inheritance
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 | Disables Always Encrypted for the query. |
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.
