This assessment is designed to test my SQL as well as C# abilities.
This Api was written in .NET8 and using Dapper micro ORM to handle the SQL Server database. The project was built to make setting up and getting started seamlessly and easy. You only need to run docker-compose -build and this will create the necessary images and setup the SQL server database. Run docker-compose up and it will spin up your two containers. One for you Database and the other for your API. Project include Swagger for ease of testing the api endpoints.
Please Note: The stored procedure can be found Here. It was added to this path to automatically run the migrations when the API starts. If I had more information and time on the implementation of this game I could've done the implementation part too in the repositories and unit tests.
Unfortunatley I was on-call last week and we had big deployments which affected my time spend on this. Thanks! I enjoyed the assessment though.
Database
DevOps
- Ensure docker is installed if not you can download it Here
docker-compose build
docker-compose up
- 1. Write a SQL Stored Procedure (pr_GetOrderSummary)
- 2. Create a C# REST API based around the game of roulette
- 3. Implementation of the entire assessment (game of roulette).