Azure SQL Managed Identity with Entity Framework Core | EF Core | ASP.NET Core

A common challenge for developers is the management of secrets and credentials used to secure communication between different components making up a solution. Managed identities eliminate the need for developers to manage credentials. Managed identities provide an identity for applications to use when connecting to resources that support Azure Active Directory (Azure AD) authentication.

In this video We are going to learn how to configure managed identity for Azure SQL with Entity Framework Core and ASP.NET.

00:00 Intro
00:10 What is Managed Identity?
01:42 Creating Resources + DB
03:45 ASP.NET Core app with EF Core
07:18 Publishing to Azure
07:30 Configuring Managed Identity for App Service

Meet Kamal Today
Kamal Rathnayake

[hutchm]

Excellent video, straight to the point. Thank you!

[meenakshimeenu]

even after doing this all changes anf after foloowingt your steps, i am still getting same issue as login failed for user identified token principle
plzz help me out

[asdasdaa]

it would be great to see how to use T-SQL to: create user [example-user] from external provider alter role db_datareader add member [example-user] in code. Should one just use the MicrosoftDataSqlClient package for this?

[harishukirade]

I think you mixed both approaches using System assigned and user assigned

[kishorekaranth]

If i am using. Net core version 2.1, should i follow same steps to achieve this? Also i have generic repository pattern to interact with database. Can you tell me what needs to be done?