dotnetcore-sqldb-tutorial's Introduction

languages

page_type

description

products

csharp

aspx-csharp

sample

This is a sample application you can use to follow along w/ the Build a .NET Core and SQL Database web app in Azure Web Apps for Containers tutorial.

azure

aspnet-core

azure-app-service

.NET Core MVC sample for Azure App Service

This is a sample application that you can use to follow along with the tutorial at Build a .NET Core and SQL Database web app in Azure Web Apps for Containers.

License

See LICENSE.

Contributing

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

Additional SQL Configuration for Managed Identities

Modify SQL Server Firewall
- Add Web Server IP Address (or just enable Azure Services Access)
Enable Managed Identity on WebApp
- Note the name of the WebApp
Grant the WebApp Access to to the database in the query editor (or SSMS)

CREATE USER [WebAppName] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [WebAppName];
ALTER ROLE db_datawriter ADD MEMBER [WebAppName];

Add packages to the project dotnet add package
- Azure.Identity
- System.Data.SqlClient
Update startup.cs in the ConfigureServices method

var connString = Configuration.GetConnectionString("MyDbConnection"); //Just need Server and Database/Initial Catalog in the conn string now
// Create a new connection
var sqlConn = new System.Data.SqlClient.SqlConnection(connString);
// Get the AD credential context for the application
var credential = new DefaultAzureCredential();
//get a token with the current app's context
var token = credential.GetToken(new Azure.Core.TokenRequestContext(new[] {"https://database.windows.net/.default"}));
// Add the token obtained to the connection to OAuth enable it
sqlConn.AccessToken = token.Token;

services.AddDbContext<MyDatabaseContext>(options =>
    options.UseSqlServer(sqlConn)); //pass the connection now, not the connection string

Recommend Projects