-
Notifications
You must be signed in to change notification settings - Fork 224
Description
I want to migrate how my local machine connects to the SQL database on Azure. Instead of having a connection string that has a SQL username + password, I'd like to authenticate using Azure Directory.
When I change my Settings.ConnectionString to:
Settings.ConnectionString = "Server=tcp:<server-name>.database.windows.net,1433;Initial Catalog=<database-name>;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication=Active Directory Default;";
The output is:
// ------------------------------------------------------------------------------------------------
// WARNING: Failed to load provider "System.Data.SqlClient" - Invalid value for key 'authentication'.
// Allowed providers:
// "System.Data.Odbc"
// "System.Data.OleDb"
// "System.Data.OracleClient"
// "System.Data.SqlClient"
// "Microsoft.SqlServerCe.Client.4.0"
// "Microsoft.Data.SqlClient"
Whilst working on migrating other parts of our infrastructure (NET 6 & NET Framework 4.8), I've seen this error when System.Data.SqlClient was used to connect to the database or when an older version of Microsoft.Data.SqlClient was used.
My assumption is that Reverse POCO is using System.Data.SqlClient as a provider to generate the model.
Is there perhaps some way to change this provider to Microsoft.Data.SqlClient?