Column Encryption Setting=Enabled 客户端没有证书的时候

 

表层错误

Failed to decrypt column 'Password'.
Failed to decrypt a column encryption key using key store provider: 'MSSQL_CERTIFICATE_STORE'. The last 10 bytes of the encrypted column encryption key are: 'A8-F2-EC-10-37-38-B7-73-81-0C'.
Certificate with thumbprint 'BADF572EE3703D411039C002C2F556D4CCC1441C' not found in certificate store 'My' in certificate location 'CurrentUser'. Verify the certificate path in the column master key definition in the database is correct, and the certificate has been imported correctly into the certificate location/store.
Parameter name: masterKeyPath

 

inner exception

Certificate with thumbprint 'BADF572EE3703D411039C002C2F556D4CCC1441C' not found in certificate store 'My' in certificate location 'CurrentUser'. Verify the certificate path in the column master key definition in the database is correct, and the certificate has been imported correctly into the certificate location/store.
Parameter name: masterKeyPath

 

#region Assembly Microsoft.EntityFrameworkCore, Version=2.2.6.0, Culture=neutral, PublicKeyToken=adb9793829ddae60
// C:\Users\clu\.nuget\packages\microsoft.entityframeworkcore\2.2.6\lib\netstandard2.0\Microsoft.EntityFrameworkCore.dll
#endregion

EntityFramework吃掉异常

Microsoft.EntityFrameworkCore

public static class EntityFrameworkQueryableExtensions

await SingleOrDefaultAsync

 

#region Assembly DevExpress.Mvvm.v21.2, Version=21.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a
// C:\Users\clu\.nuget\packages\devexpress.mvvm\21.2.5\lib\net452\DevExpress.Mvvm.v21.2.dll
#endregion

DevExpress.Mvvm

最后发现异常是被这个AsyncCommand吃掉的

 

作者:Chuck Lu    GitHub