New SQL Datasource Reference
The new SQL Datasource type was introduced in Fluent version 25.3.1.
Overview
Prior to version 25.3.1, Fluent used the System.Data.SqlClient namespace to handle connections to SQL datasources. This has been updated to a newer Microsoft.Data.SqlClient namespace in recent years so we've made the upgrade as well. This comes with a couple changes which we will discuss.
Connections Encrypted By Default
Although everything in the Microsoft.Data.SqlClient namespace is meant to be backward compatible, there is one big change in functionality. All connections are encrypted by default. This means if you are connecting to a SQL Server that is using a self-signed certificate, you now must explicitly specify TrustServerCertificate=True in your connection string.
In Fluent Designer, we've made this easy by including a checkbox for SQL connections when creating or updating your datasource:
New Datasource Type
To ensure backwards compatibility to old DB connections setup in Fluent Designer, we've added a Legacy Sql Server Database. With this change we have:
Sql Server Database: Connection to Sql Databases leveraging the Microsoft.Data.SqlClient namespace.
Sql Server (Legacy) Database: Connection to Sql Databases leveraging the System.Data.SqlClient namespace.
