Skip to content

[release/11.0.1xx-preview3] Add Microsoft.Data.SqlClient.Extensions.Azure to Individual Auth templates#5916

Merged
wtgodbe merged 1 commit intorelease/11.0.1xx-preview3from
wtgodbe/AddSqlClientExtensionsAzure
Apr 7, 2026
Merged

[release/11.0.1xx-preview3] Add Microsoft.Data.SqlClient.Extensions.Azure to Individual Auth templates#5916
wtgodbe merged 1 commit intorelease/11.0.1xx-preview3from
wtgodbe/AddSqlClientExtensionsAzure

Conversation

@wtgodbe
Copy link
Copy Markdown
Member

@wtgodbe wtgodbe commented Apr 6, 2026

In .NET 11 Preview 3, Microsoft.Data.SqlClient moved Active Directory authentication providers to a separate package (Microsoft.Data.SqlClient.Extensions.Azure). When publishing Individual Accounts templates to Azure App Service with Azure SQL, Visual Studio configures the connection string with Authentication=Active Directory Default, which requires this package. Without it, users get:

Cannot find an authentication provider for 'ActiveDirectoryDefault'.
Install the 'Microsoft.Data.SqlClient.Extensions.Azure' NuGet package to use Active Directory (Entra ID) authentication methods.

This adds Microsoft.Data.SqlClient.Extensions.Azure v1.0.0 to all three affected templates:

  • MVC (StarterWeb-CSharp.csproj.in)
  • Blazor (BlazorWebCSharp.csproj.in)
  • Razor Pages (RazorPagesWeb-CSharp.csproj.in)

The package reference is conditional on IndividualLocalAuth + UseLocalDB (the SQL Server path).

Fixes dotnet/aspnetcore#66107

Backport of dotnet/aspnetcore#66179

…lates

Co-authored-by: Copilot <223556219+Copilot@users.noreply.github.com>
@dotnet-policy-service dotnet-policy-service bot requested a review from a team April 6, 2026 20:18
@wtgodbe wtgodbe changed the title Add Microsoft.Data.SqlClient.Extensions.Azure to Individual Auth templates [release/11.0.1xx-preview3] Add Microsoft.Data.SqlClient.Extensions.Azure to Individual Auth templates Apr 6, 2026
@wtgodbe wtgodbe added the Servicing-approved Approved for servicing release label Apr 6, 2026
@wtgodbe
Copy link
Copy Markdown
Member Author

wtgodbe commented Apr 6, 2026

Approved over email

@wtgodbe wtgodbe requested a review from AndriySvyryd April 6, 2026 20:24
@wtgodbe
Copy link
Copy Markdown
Member Author

wtgodbe commented Apr 7, 2026

/azp run

@azure-pipelines
Copy link
Copy Markdown

Azure Pipelines successfully started running 2 pipeline(s).

@wtgodbe wtgodbe merged commit a8b33e7 into release/11.0.1xx-preview3 Apr 7, 2026
56 of 63 checks passed
@wtgodbe wtgodbe deleted the wtgodbe/AddSqlClientExtensionsAzure branch April 7, 2026 19:10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Servicing-approved Approved for servicing release

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants