0

I am trying to configure the connection string to use Azure AD Authentication. I am able to connect to SQL Server using standard SQL Connection with Azure AD Authentication. My application uses Entity Framework 6 DataBase first approach. I have override the DbContext to generate the connection string at run time. Is it possible to configure the Azure AD AUthentication for EF 6 Data Base First approach.

I am getting keyword metadata not supported when trying to connect with standard SQL connection as my model is build using Database first approach. If am removing metadata from connection string then am getting Untintional Code First exception.

How can I configure EF 6 DataBase first approach with Azure AD Authentication

Improve this question
1
  • Wondering if you found a solution? Commented Jun 29, 2023 at 16:21

1 Answer 1

Reset to default
0

I think you can ref this post: Entity Framework connection to SQL Azure DB using access token.

I don't if he uses the Database-first model, I think it's helpful for you to configure the AAD access token.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.