To learn about projection, it is best to have some more complex sequences to work with; so, in the next project, we will use the Northwind sample database.
Using LINQ with EF Core
Projecting entities with Select
Add a new console application project named LinqWithEFCore.
In Visual Studio 2017, in the LinqWithEFCore project, right-click on Dependencies and choose Manage NuGet Packages.... Search for the Microsoft.EntityFrameworkCore.SqlServer package and install it.
If you did not complete Chapter 11, Working with Databases Using Entity Framework Core, then open the Northwind4SQLServer.sql file, and right-click and choose Execute to create the Northwind database on the server named (localdb)\mssqllocaldb.
In Visual Studio Code...
