Connect with Azure SQL using "Authentication=ActiveDirectoryInteractive"
I'm having trouble getting the "Entity Framework Core (multi-provider)" data context to work well in LINQPad 7 when using the "Azure Active Directory - Universal with MFA" authentication mode.
If I use a LINQ to SQL connection using the built-in LINQPad driver, it all seems to work fine. I've been using the LINQ to SQL mode for years and have no complaint, but I wanted to try moving to the native EF Core support so that I can stay in one dialect all the time. When I try the built-in support for EF Core, I get prompted to choose my account every single time I run a query, though.
I was able to use a typed dataset from my project, but I switch branches frequently, and I'm not always in a stable state. I thought that the option to automatically build the data context sounded like a good idea since it would isolate LINQPad from the frequent changes to my dll.
Am I missing something simple here?