SQL Server 2022 support
Starting with version 2.3.0 we now support targeting SQL Server 2022 with MSBuild.Sdk.SqlProj. Thanks to @ErikEJ for his contribution.
Note: In this release we've made a change so that when using
dotnet publish
to deploy your project to a development SQL Server we're not using an encrypted connection by default (ie. the connection string'sEncrypt
property is set toFalse
). As development SQL Servers typically don't have a TLS certificate and ourdotnet publish
support is targeted at development scenario's we feel that this is a good default. For production deployments we recommend using thesqlpackage
tool, which fully supports encrypted connections.