I am very new to nopCommerce, and Visual Studio. I have over 10 years of daily experience coding in classic ASP, but am clueless with this stuff.
Get nopcommerce site running locally, then publish to a dedicated server, but with the database running on SQL Azure.
Progress thus far:
Site is running at localhost on CE edition of SQL Server.
I have successfully created a SQL Azure database and run the Azure migration assistant. Now I have exact copy of database running on Azure, but I cannot figure out how to change the connection properties. I see a section in the web.config that refers to the SQL Server CE:
<remove invariant="System.Data.SqlServerCe.4.0" />
<add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=22.214.171.124, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
I'm not sure how to change that, or if that's even what I'm supposed to change..
I tried adding this to the web.config(with actual values), but it is still pulling data from the local machine:
<add connectionString="Server=xxxxxx.database.windows.net;Uid=MY-UID-HERE;Database=MY-DATABASE-NAME-HERE;Pwd=MY-PASSWORD-HERE" name="MY-DATABASE-NAME-HERE" providerName="System.Data.SqlClient" />
Any help would be greatly appreciated-