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.
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, modify the LinqWithEFCore.csproj
file as highlighted in the following markup:
<Project Sdk="Microsoft.NET.Sdk"> <PropertyGroup> <OutputType>Exe</OutputType> <TargetFramework>netcoreapp1.1</TargetFramework> </PropertyGroup...