About EfCoreInAction

Entity Framework Core in Action

Welcome to the Live example book selling site that is used to show some of the code from the book Entity Framework Core in Action working on a hosted site. Please visit the Manning Publications site to find out more about the book and its content.

What am I seeing?

This site is currently running a two-database CQRS (Command Query Responsibility Segregation) architecture application using a polyglot database structure. This means:

  1. CQRS: This architecture splits reads from writes into two different parts. This is done to allow the reads to be performance tuned by saving the exact data that is to be shown to the user, thus saving calculations being done at read-time.
  2. Polyglot database structure: This means I use different types of databases for the read and write sides of the CQRS system. I use the two types of databases:
    • A NoSQL database, RavenDb, for my read-side database. Kindly hosted by RavenHQ.
    • A SQL Server database hosted on my web host provider, Web Wizz.

See the article "EF Core – Combining SQL and NoSQL databases for better performance" for a full write-up!

The database contains 250,000 books, plus other entities as shown in the table below. This is test data I use for performance testing, and I build data using 300 real books from Manning's site and replicating it multiple times.

Books Reviews BookAuthor Authors
The books! Holds reviews of the books Many-to-Many linking table Authors
250,000 1,374,985 470,517 580

You can't change the data, for obvious reasons, but you can 'buy' a book or two - no money needed, but then again we don't send you the books either :)
Note: the checkout will use a cookie to hold your order.

You can download and run the application locally, which allows you to change the data, if you clone the github repo (see the book) which goes with the book.

Jon P Smith

Author of the Entity Framework Core in Action book.

My blog site, where you will find articles on Entity Framework, ASP.NET, React.js and much more.
Entity Framework Core in Action

This application was built from git branch: Chapter14

Updates are DISABLED because the application is running hosted.

Versions this application uses

Assembly Version
Microsoft.EntityFrameworkCore 2.0.0.0
Microsoft.AspNetCore.Hosting 2.0.0.0
Targeted .NET Core .NETCoreApp,Version=v2.0