This is a Contact Management Demo created as job interview exercise.
The following need to be installed:
- Visual Studio 2019
- Node.js
- npm
- SQL Server (Development Edition or and Azure instance works)
- Git
The source can be downloaded by using the following command:
git checkout https://github.com/sourcevelocity-andy/cms-demo.git
Create a database instance.
There is a SQL script in the root folder of the project named "Database Setup Script.sql." Run this script against the database instance and it will setup the required tables.
The application uses a connection string labeled "DefaultConnection" to access the database. In order to not expose database settings to the world, the connection string is stored in the secrets.json file.
This can be access by opening the project in Visual Studio, right-clicking the project, and selecting "Manager User Secrets." Add the following key (with the fields updated to reflect your SQL login):
{ "ConnectionStrings": { "DefaultConnection": "Server=localhost;Database=cms-demo;User Id=[cms-demo];Password=[password]" } }
At this point the application should run without any problems.
In the future, here are some improvements that could be made:
- More unit tests
- Code cleanup
- Reduce javascript library dependencies
- New features