If you are developing using Episerver Commerce, you can use the QuickSilver site for code examples and for testing the Commerce API. Here's how to set one up.
- An instance of SQL, either on the server or another box.
- An AD user with dbcreator on the SQL instance to run the database install.
- Download a Quicksilver project from github: https://github.com/episerver/Quicksilver. You can place the files anywhere in your file system.
- Give the user who will be building the project full control permissions over the Quicksilver files. This is important as otherwise you will get "Access Denied" errors in step 15.
- In Visual Studio > Nuget package manager settings, add the following to the package sources:
- Open the Quicksilver solution file, C:\inetpub\Quicksilver-master\Quicksilver.sln.
- In Solution Explorer, right click the solution and click Properties.
- Choose startup project, then select the Single startup project option. Set the dropdown to Commerce site. This causes the commerce site to be loaded upon debugging.
- Build the solution in Visual Studio.
- Open C:\inetpub\Quicksilver-master\Setup\SetupDatabases.cmd.
- Near the beginning, you see the following code. Change the database name and user to your preference. Running the .cmd file creates two databases and a SQL account to connect to the database.
set user=Quicksilver set password=Episerver15
- Modify the following statement so the correct database instance is set. Because the database server is currently set to '.' there is no SQL instance specified.
set sql=sqlcmd -S . -E
If you are using SQL Express, use the following command instead.
set sql=sqlcmd -S .\SQLExpress -E
Note: If the full version of Microsoft SQL Server is installed on the local machine, and there is no named SQL instance, you can leave the first set sql command unmodified. Otherwise, change the instance to the preferred SQL machine and instance.
If mixed mode authentication is not enabled or you want to use a SQL user, edit this line in SetupDatabases.cmd and provide a username and password.
set sql=sqlcmd -S SQLServerName\SQLInstanceName -U username -P password
- Save the file.
- Open the connectionstrings.config files of the EPiServer.Reference.Commerce.Manager and EPiServer.Reference.Commerce.Site source folders. Modify the connection strings to your intended database name, SQL server, and user.
- If you are using SQL Express locally change "Data Source=." to "Data Source=.\SQLExpress". Otherwise, modify the connection strings to reflect the intended location of the Quicksilver.Cms and Quicksilver.Commerce databases. For instance, "Data Source=SQLServerName\SQL2014." If you change the user or database name in step 11, you also need to change the user and database names in the connection strings.
- Run Setup\SetupDatabases.cmd to create the databases. The AD user running that file must have the dbcreator role on the SQL instance. Do not use the "run as administrator" option.
- Press F5 to load the site.
- Append /episerver/admin to your site url. E.G. http://localhost:50244/episerver/.
- Login with the credentials email@example.com/store.