Apologies up front for my lack of SQL knowledge.
I have a database in the app_data folder of my Asp.Net web application.
The database contains simple page meta data for the application.
I have a few questions.
First, here's my connection string from my development machine. It uses Visual Studios built in SQL - I'm guessing some variant of SQL Server Express.
This needs to be transformed so that it works on the live server, however the live server runs SQL Server 2014 Web Edition - what do I need to change, assuming it will still reside in the app_data folder?
<add name="CMSEntities" connectionString="metadata=res://*/CmsModel.csdl|res://*/CmsModel.ssdl|res://*/CmsModel.msl;provider=System.Data.SqlClient;provider connection string="data source=(LocalDB)\MSSQLLocalDB;attachdbfilename=|DataDirectory|CMS.mdf;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
Secondly are there any other changes that should be made to the string with regards to security etc?
Lastly, is it bad practice to use the app_data folder in the first place?
Thanks in advance.