Building an entity data model for Northwind
Practical applications usually need to work with data in a relational database or another data store. In this chapter, we will define an entity data model for the Northwind database stored in SQLite. It will be used in most of the apps that we create in subsequent chapters.
Although macOS includes an installation of SQLite by default, if you are using Windows or a variety of Linux then you might need to download, install, and configure SQLite for your operating system. Instructions to do so can be found in Chapter 11, Working with Databases Using Entity Framework Core.
Good Practice: You should create a separate class library project for your entity data models that does not have a dependency on anything except .NET Standard 2.0. This allows easier sharing between backend servers and frontend clients without the client needing to reference Entity Framework Core 3.0, that is dependent on .NET Standard 2.1.