below connection strings have asp.net project built in visual studio. once folder contains prokject tried open on different computer database connection errors, there way can make these connection strings portable project wont run on computer only?
<connectionstrings> <add name="nas_connect" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename=|datadirectory|app_code\nas.mdf;integrated security=true" providername="system.data.sqlclient" /> <add name="nasconnectionstring" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename="app~_code\nas.mdf";integrated security=true;connect timeout=30" providername="system.data.sqlclient" /> <add name="nasconnectionstring2" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename="app_code\nas.mdf";integrated security=true;connect timeout=30" providername="system.data.sqlclient" /> <add name="nasconnectionstring3" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename="\app_code\nas.mdf";integrated security=true;connect timeout=30" providername="system.data.sqlclient" /> <add name="nasconnectionstring4" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename="\app_code\nas.mdf";integrated security=true;connect timeout=30" providername="system.data.sqlclient" /> <add name="insert into" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename="\app_code\nas.mdf";integrated security=true;connect timeout=30" providername="system.data.sqlclient" /> </connectionstrings> any appreciated
thank you.
firstly ensure copy database files computer. mean mdf , ldf files.(these files should here webroot/app_code/.) , ensure install sqllocaldb.msi computer. if want have different configuration on different environments, suggest use config file transformation. can using example slowcheetah 1 can download using vs tools , extensions.
references:
1) https://msdn.microsoft.com/en-us/library/hh510202.aspx
2) slowcheetah
