Databases for software developers

Databases for software developers - Nicklas Millard - Mjukvare/The Better Software Initiative
Fast-paced and in-depth workshop on broadly applicable principles, practices, and standards for working with databases through code using C# Entity Framework Core.

Clone the GitHub repo: https://github.com/codeclubcph/dotnet-ef-workshop/

Prerequisites

• .NET 8 SDK installed
• IDE capable for .NET development (Visual Studio, Rider)
• Docker desktop

Workshop structure
Production-grade migrations and entity configurations

• Configuring entities and tables.
• Database migrations.
• Seeding data.
• Generating idempotent scripts.

Effective test strategies

• Pitfalls of mocking and in-memory databases.
• Using testcontainers for increased test confidence.
• Strategies for testing write logic.

Polymorphism using tables and JSON columns

• Base classes and sub-types with tables.
• Storing interface implementations in JSON columns.
• JSON ValueConverter vs. the new ToJson() configuration.

Entity relationships

• One-to-one.
• Many-to-one.
• Many-to-many.

Duration: 2 hours
Location: Online (google meet)
Price: free

Target audience
This workshop is aimed at software developers with experience in an object-oriented language and relational databases. If you are already an expert in OR/Ms and code first database strategies, then this is not for you.