Skip to content

This assessment is designed to test my SQL as well as C# abilities.

Notifications You must be signed in to change notification settings

Reagang/derivco_tech_assessment

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 

Repository files navigation

Derivco Technical Assessment

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.

📔 Table of Contents

🌟 About the Project

👾 Tech Stack

Tech Choice
Database
DevOps

🧰 Getting Started

‼️ Prerequisites

  • Ensure docker is installed if not you can download it Here

⚙️ Installation

docker-compose build
docker-compose up

Demo Screenshot

Alt text

🧭 Roadmap

  • 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).

About

This assessment is designed to test my SQL as well as C# abilities.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published