Databases for software developers
Details
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.
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.
Prerequisites
- .NET 8 SDK installed
- IDE capable for .NET development (Visual Studio, Rider)
- Docker desktop
Databases for software developers