时间戳

首页 > 解决方案 > .NET Core 3.1 始终加密

always-encrypted - .NET Core 3.1 始终加密

问题描述

使用 .NET Core 3.1 和 SQL Always Encrypted 时出现以下错误。这在 3.1 中是否支持？也许我在这里遗漏了一些东西..

Keyword not supported: 'column encryption setting'.

目前已安装以下软件包

    <PackageReference Include="Microsoft.ApplicationInsights.AspNetCore" Version="2.12.0" />
    <PackageReference Include="Microsoft.AspNetCore" Version="2.2.0" />
    <PackageReference Include="Microsoft.AspNetCore.Mvc" Version="2.2.0" />
    <PackageReference Include="Dapper" Version="2.0.30" />
    <PackageReference Include="Microsoft.AspNetCore.Razor.Design" Version="2.2.0" PrivateAssets="All" />
    <PackageReference Include="Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider" Version="1.0.0" />
    <PackageReference Include="Microsoft.Extensions.Configuration.AzureKeyVault" Version="3.1.1" />
    <PackageReference Include="Serilog.AspNetCore" Version="3.2.0" />
    <PackageReference Include="Serilog.Extensions.Logging" Version="3.0.1" />
    <PackageReference Include="Serilog.Settings.Configuration" Version="3.1.0" />
    <PackageReference Include="Serilog.Sinks.ApplicationInsights" Version="3.0.4" />
    <PackageReference Include="Serilog.Sinks.Console" Version="3.1.1" />

标签： always-encryptedasp.net-core-3.1.net-core-3.1

解决方案

需要将以下包引用添加到Microsoft.Data.SqlClient（请参阅nuget）并使用 thisMicrosoft.Data.SqlClient和 NOT System.Data.SqlClient。

    using (var conn = new Microsoft.Data.SqlClient.SqlConnection(connectionString))
    {
        await conn.OpenAsync();
    }

推荐阅读