LocalDB using in Azure App service

Question

I have the below connection string in Web config and works fine in Visual Studio.

<connectionStrings>
   <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-MyPortal-20170627104450.mdf;Initial Catalog=aspnet-MyPortal-20170627104450;Integrated Security=True" providerName="System.Data.SqlClient" />
</connectionStrings>

I tried porting my ASP.NET MVC application to Azure using Azure App service and Azure AD. I changed AttachDbFilename attribute as below

AttachDbFilename=\App_Data\aspnet-MyPortal-20170620051631.mdf

I am getting below error:

Invalid value for key 'attachdbfilename'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Invalid value for key 'attachdbfilename'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

App Data folder does contain the mdf file. How do I refer it in the connection string in web config?

Is there any sample program for Azure Web app getting authenticated with Azure AD?

Answer 1

In brief, you cannot use LocalDB in Azure App Service.

There is another answer - How to connect a localdb from Visual Studio to the published Azure web app?

Answer 2

working fine now. Made changes to connection String in Webconfig as below. Removed the AttachDBFilename attribute in the connection string and included the Azure DB.

<add name="DefaultConnection" connectionString="Server = tcp:myserverazure2017.database.windows.net,1433; Initial Catalog = MyDBPro; Persist Security Info = False; User ID = ****; Password = ****; MultipleActiveResultSets = False; Encrypt = True; TrustServerCertificate = False; Connection Timeout = 30;" providerName="System.Data.SqlClient" />