Scaffold-DbContext probleme authentication integrated security

Question

Hello
I want scaffolding my azure sqserver database, but when i run this command :

Scaffold-DbContext "Server=MydataBase.database.windows.net;Database=dev-base;Integrated security=true;Authentication=Active Directory Integratd;User ID=myUser;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models

I have this error : Cannot use 'Authentication' with 'Integrated Security'

Someone can help me ?

Answer 1

You have a wee bit too many things in your connection string (which is also what the error message is telling you).

You have:

1. Integrated security=true;
2. Authentication=Active Directory Integratd;User ID=myUser;
3. Trusted_Connection=True;

The first and the third mean the same. The second is in contradiction to the other to. Decide which authentication method you want and remove the rest.

Answer 2

I have this error : Cannot use 'Authentication' with 'Integrated Security'

"Integrated Security" means to logon with a local Active Domain account; that's not supported by Azure SQL. You have to choose an other authentication method, see

An overview of Azure SQL Database and SQL Managed Instance security capabilities