Connection strings for frontent/manager site mismatch when creating site in VS2015

Found in

EPiServer.CommerceManager 8.15

Created

Aug 04, 2015

Updated

Aug 21, 2015

Area

Falcon/Commerce/Commerce Manager

State

Closed, Fixed and Tested


Steps to reproduce

Steps to reproduce

  1. Install VS2015 and EPiServer VS Extension
  2. Create a new EPiServer site using extension
  3. Install EPiServer.Commerce package in created project
  4. Run Update-EPiDatabase in package manager console
  5. Create a blank asp.net web application projet in the same solution (mine creates a .NET 4.5.2 project with these ProjectTypeGuids: {349c5851-65df-11da-9384-00065b846f21};{fae04ec0-301f-11d3-bf4b-00c04f79efbc})
  6. Install EPiServer.CommerceManager package in the new project
  7. Start the frontend site (debug - start without debugging etc). The site starts fine and starts migrating.
  8. Start the commerce manager site (right click project, view - in browser etc.)

Expected: Commerce manager is accessible

Actual: YPOD with exception in database version


Cause: The connection string added to the manager site does not match the one in the frontend site. In VS2013 they are both "(LocalDb)\v11.0;AttachDbFilename=..." while in VS2015 the one in the frontend site is "(LocalDb)\MSSQLLocalDB;AttachDbFilename=..."