Exercise 8

• Change one of your backend to use database.
• You can use SQL Server Express (https://www.microsoft.com/en-us/sql-server/sql-server-downloads) or PostgreSQL (https://www.postgresql.org/)
• To access the database, you can use one of the listed ORM here (https://tortugaresearch.github.io/DotNet-ORM-Cookbook/ORMs.htm).
• SilverKey has been using LLBLGen Pro for the past 15 years at least and build all of our software using this but you might have different opinion
  • If you are using LLBLgen Pro, you can install the trial version here.
  • Use FluentMigrator to manage your schema.
• Otherwise you can use DbUp or other tools to manage your database schema.

Todo

• Document your database schema first
• Generate the schema using a tool. Do not create schema manually.
• Connect to the created database using an ORM.
• Rewire your backend.

If you choose not to use LLBLGenPro and FluentMigrator, I cannot assist you since I don't have any experience with the others