Is there are way to use a Azure SQL Database connection from an App Service using a managed identity?

The article below requires that you have access to the connection object to set an access token in order to use the managed identity.

https://docs.microsoft.com/en-us/azure/app-service/app-service-web-tutorial-connect-msi

Is this question related to LLBLGen Pro?

I think you mean this:

conn.AccessToken = (new AzureServiceTokenProvider()).GetAccessTokenAsync("https://database.windows.net/").Result;

?

so the ability to set that property? It's the easiest in adapter: create a partial class of the generated DataAccessAdapter class and override the CreateNewPhysicalConnection method. Then first call the base method to get the DbConnection instance, then cast it to SqlConnection and set the property with the value you want.

Thank you everyone for your responses. Is there a way to do this in SelfServicing mode?

Please try this: In the CommonDaoBase class, override CreateConnection as follows:

public override DbConnection CreateConnection(string connectionString)
{
    SqlConnection con = (SqlConnection)base.CreateConnection(connectionString);
    con.AccessToken= ....
    return con;
}

Great! Thank you!! I will try this out in the next several days and let you know how it went.

Thanks for the help. I implemented your suggested changes after setting up the Managed Identity and it works great. Here is the override code that I used. I put this in it's own file:

using Microsoft.Azure.Services.AppAuthentication; using SD.LLBLGen.Pro.ORMSupportClasses; using System.Data.Common; using System.Data.SqlClient;

namespace coetzeeModel.DaoClasses { public partial class CommonDaoBase : DaoBase {

    public override DbConnection CreateConnection(string connectionString)
    {
        SqlConnection con = (SqlConnection)base.CreateConnection(connectionString);
        con.AccessToken = (new AzureServiceTokenProvider()).GetAccessTokenAsync("https://database.windows.net/").Result;
        return con;
    }
}

}

Hi Jim,

Thanks for the feedback and the code