LINQ with EF Core
Explore how to project and query complex data by building an EF Core model representing a database. This lesson guides you through setting up a SQLite database with the Northwind sample schema, creating entity classes, and using LINQ queries to manipulate data effectively.
We'll cover the following...
Projection
We have looked at LINQ queries that filter and sort, but none that change the shape of the items in the sequence. This is called projection because it’s about projecting items of one shape into another. To learn about projection, it is best to have some more complex types to work with, so in the next project, instead of using string sequences, we will use sequences of entities from the Northwind sample database. We will give instructions to use SQLite because it is cross-platform, but if we prefer ...