Movies Microservice Technical Demo

Version: 1.0

Structure:

Contains all the basic methods and classes to be used across the application

Basic Memory Cache implementation

Defines the application entities plus access layer called Managers

Contains the elements that the system needs to use Entity Framework such as the DbContext plus Repoistory patter implementation

Contains the elements to run GraphQL built on top of Entity Framework

Contains all that is needed to expose a specific Orleans grains

API ingress application

Download the source code and open using Visual Studio (TechDemo.Movies.sln)
Open SQL Management Studio and connect to database using connection string: (LocalDB)\MSSQLLocalDB. This will connect to a local instance of SQL server
Under the API project you should find a folder called "Schema_Setup". Open file "00 - Schema Setup.sql"
Modify the paths found under "FILENAME" that make sense to your setup
Execute the file. This should create the basic schema plus also insert the sample data
If you plan to run Orleans with DB Storage, then execute also "01 - Orleans Query Creation.sql" and "02- Orleans Query Store Storage Creation.sql" (by default we are using Memory and not SQL Server)
Set TechDemo.MoviesDb.API as startup project and launch
The landing page should be a swagger interface allowing you to invoke the apis from it (swagger/index.html)
To test out graphql, please navigate to "ui/playground"

All logs are being fed to console, including Entity Framework SQLs
All API error responses have been normalised into a uniform error handler for easier website error handling
All exceptions have a unique identifier to help troubleshoot issues further