I presume that LocalDB does not support Azure AD auth, as I receive the following error message:
CREATE USER [myuser] FROM EXTERNAL PROVIDER;
Incorrect syntax near 'PROVIDER'.
(I'm attempting to create a Local DB for integration testing from the same DacPac).
However I cannot find any documentation that suggests explicitly that LocalDB (nor SQL Express) does not support Azure AD Auth.
Experience has found that just because it's not documented doesn't mean it's not possible.
In Azure SQL Server, you activate AD auth by assigning an Azure AD user to be an administrator, which can be done via AzureRM powershell module. Is there an equivalent none azurerm way of achieving the same thing?