Using EF Core with Azure Cosmos DB

With Azure Cosmos DB, Microsoft offers different databases with several APIs that make use of the same infrastructure. Most of these database offerings are NoSQL databases for different purposes. Azure Cosmos DB offers a JSON document store that can be accessed with the Mongo DB API. The Apache Cassandra API offers a wide column store where each row can have different columns. The Apache Gremlin query language can be used to access a graph version of the database. This is great to query for relations using vertices and edges. Azure Cosmos DB for PostgreSQL is a distributed high-performance relational database using the same infrastructure to read and write from a database network worldwide.

For the codebreaker solution, we’ll use Azure Cosmos DB for NoSQL. Here, an EF Core provider is available. This allows us to use the same API as with SQL Server, but the mapping will be different.

Writing the games and moves to Azure Cosmos DB, we...