14 Different database types and EF Core services

This chapter starts with the differences you might encounter in the range of relational databases that EF Core supports. To bring this to life, you’ll convert our book app from using SQL Server to the MySQL database to see what changes. I make that application available in the Git repo branch Chapter14MySql.

You’ll then look at the Command Query Responsibility Segregation (CQRS) architecture discussed at the end of the preceding chapter (see section 13.6). We’ll spend quite a bit of time on this, as it’s a useful architecture and its implementation highlights advanced features inside EF Core. You’ll also add a NoSQL database to the mix to end up with a high-performance version of our original book-selling site application. It might not challenge Amazon, but it’s still pretty fast for a single-instance ASP.NET Core application. This application is available on the book’s Git repo branch Chapter14 as well as on a live site at http://cqrsravendb.efcoreinaction.com/.

14.1 What differences do other database server types bring?

14.1.1 Creating an instance of the application’s DbContext for MySQL

14.1.2 What you have to do to convert the SQL Server application to MySQL

14.1.3 Looking at other database server types and differences

14.1.4 Summarizing EF Core’s ability to work with multiple database types

14.2 Developing a CQRS architecture application with EF Core

14.2.1 Implementation of a two-database CQRS architecture application

14.2.2 How the parts of the CQRS solution interact with each other

14.2.3 Finding book view changes—Part 1, finding the correct state and key

14.2.4 Finding the book view changes—Part 2, building the correct State

14.2.5 Why the CQRS solution is less likely to have out-of-date cached values

14.2.6 Is the two-database CQRS architecture worth the effort?

14.3 Accessing and changing EF Core services

14.3.1 Accessing an EF Core service to help in your own application

14.3.2 Replacing an EF Core service with your own modified service

14.4 Accessing command-line tools from software

14.4.1 How to access EF Core design-time services

14.4.2 How to use design-time services to build the EfSchemaCompare tool

Summary