DotNet6-Docker链接Sql-Server问题

Sql Server 命名实例设置

默认安装的命名实例，需要单独设置端口号。

设置成功后，需要重启服务。

DotNet 链接字符串设置

使用 SqlSugarCore 版本：5.1.2.6，连接测试：


//创建数据库对象
SqlSugarClient db = new SqlSugarClient(new ConnectionConfig()
{
    // 成功
    //ConnectionString = @"Encrypt=True;TrustServerCertificate=True;Persist Security Info=False; User ID=test; Password=1234567; Initial Catalog=ConfigCenter; Server=10.10.0.36;",

// 成功
    //ConnectionString = @"Encrypt=True;TrustServerCertificate=True;Persist Security Info=False; User ID=sa; Password=1234567; Initial Catalog=ConfigCenter; Server=10.10.0.36;",

// 成功
    // ConnectionString = @"Encrypt=True;TrustServerCertificate=True;Persist Security Info=False;Initial Catalog=LimsBase;User Id=sa;Password=1234567;Server=10.10.0.36;",

// 成功
    //ConnectionString = @"Encrypt=True;TrustServerCertificate=True;Persist Security Info=False;Initial Catalog=LimsBase;User Id=sa;Password=123123@$321!;Data Source=10.10.0.36,1435;",

// 成功
    ConnectionString = "Server=10.10.0.36,1435;Database=LimsBase;User=sa;Password=123123@$321!;MultipleActiveResultSets=True;",

DbType = DbType.SqlServer,
    IsAutoCloseConnection = true
});

//调试SQL事件，可以删掉 (要放在执行方法之前)
db.Aop.OnLogExecuting = (sql, pars) =>
{
    Console.WriteLine(sql); //输出sql,查看执行sql 性能无影响
};

Dockerfile 设置

SQL Server 2016、SQL Server 2017 和 SQL Server 2019 支持 TLS 1.2，无需设置。

低版本 SQL Server 默认不支持 TLS 1.2（可以安装补丁包，详情：KB3135244 - TLS 1.2 对 Microsoft SQL Server），但是在 Docker 映像容器、Unix 客户端或 Windows 客户端等客户端环境中，其中 TLS 1.2 是支持的最低 TLS 协议，所以需要设置 TLS 版本。

#See https://aka.ms/containerfastmode to understand how Visual Studio uses this Dockerfile to build your images for faster debugging.

FROM mcr.microsoft.com/dotnet/runtime:6.0 AS base

# 设置TLS版本
RUN sed -i 's/DEFAULT@SECLEVEL=2/DEFAULT@SECLEVEL=1/g' /etc/ssl/openssl.cnf
RUN sed -i 's/MinProtocol = TLSv1.2/MinProtocol = TLSv1/g' /etc/ssl/openssl.cnf
RUN sed -i 's/DEFAULT@SECLEVEL=2/DEFAULT@SECLEVEL=1/g' /usr/lib/ssl/openssl.cnf
RUN sed -i 's/MinProtocol = TLSv1.2/MinProtocol = TLSv1/g' /usr/lib/ssl/openssl.cnf
WORKDIR /app

FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build
WORKDIR /src
COPY ["ConsoleApp1/ConsoleApp1.csproj", "ConsoleApp1/"]
RUN dotnet restore "ConsoleApp1/ConsoleApp1.csproj"
COPY . .
WORKDIR "/src/ConsoleApp1"
RUN dotnet build "ConsoleApp1.csproj" -c Release -o /app/build

FROM build AS publish
RUN dotnet publish "ConsoleApp1.csproj" -c Release -o /app/publish /p:UseAppHost=false

FROM base AS final
WORKDIR /app
COPY --from=publish /app/publish .
ENTRYPOINT ["dotnet", "ConsoleApp1.dll"]