I have a database first EF6 project where I need to update the EDMX model from the database schema. Until now we have been using SQL Authentication and have no issues, however we have now moved away from SQL Auth and need to use Microsoft Entra MFA. Since EF6 does not support Active Directory Interactive, updating the model is not working.

Using other modes of Active Directory like integrated are not supported by company policy. Upgrading to EF Core seems like a huge effort considering the size of my project.

The connect itself succeeds, and I am able to view the list of databases. Is there any way to update the model? I can connect to the database using SSMS and Microsoft Entra MFA.

Basically need a way to provide a token authenticated connection to EF6 EDMX update wizard.