Modern C# and .NET Tutorial: Cross-Platform Basics/

...

LINQ with EF Core

Learn about projection in LINQ, and how to build an EF Core model to work with sequences of entities from a database using SQLite or SQL Server.

We'll cover the following...

Projection
Building an EF Core model
- Try it yourself
Using Visual Studio 2022 with SQLite databases

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 to use SQL Server, feel free to do so.

Building an EF Core model

We must define an EF Core model to represent the database and tables we ...

Introduction

Hello, C#! Welcome, .NET!

Speaking C#

Controlling Flow, Converting Types, and Handling Exception

Writing, Debugging, and Testing Functions

Building Your Own Types with Object-Oriented Programming

Implementing Interfaces and Inheriting Classes

Packaging and Distributing .NET Types

Working with Common .NET Types

Working with Files, Streams, and Serialization

Working with Data Using Entity Framework Core

Querying and Manipulating Data Using LINQ

Introducing Web Development Using ASP.NET Core

Building Websites Using ASP.NET Core Razor Pages

Building Websites Using the Model-View-Controller Pattern

Building and Consuming Web Services

Building User Interfaces Using Blazor

Conclusion

LINQ with EF Core

Projection

Building an EF Core model