Includes index.

At a Glance -- Contents -- About the Authors -- About the Technical Reviewer -- Acknowledgments -- Introduction -- Part I: Visual Studio 2017 and .NET Core -- Chapter 1: Introducing Entity Framework Core -- The SpyStore Database -- Installing Visual Studio 2017 and .NET Core -- Installing Visual Studio -- Installing the .NET Core SDKs -- The .NET Core Command Line Interface (CLI) -- Creating and Configuring the Solution and Projects -- Creating the Solution and Projects -- Changes to the Project Files -- Updating the Target Framework -- Working with NuGet Packages -- Manually Restoring Packages.

Restoring Packages from the CLIRestoring with Package Manager Console -- Adding the Project References -- Adding Entity Framework Core -- Adding EF Packages to the SpyStore. DAL Project -- Installing/Updating Packages Using the SpyStore. DAL.csproj File -- Adding EF Packages to the SpyStore. Models Project -- Adding Packages to the SpyStore. DAL. Tests Project -- Building the Foundation -- Understanding the DbContext Class -- Creating the StoreContext Class -- Understanding the DbSet Collection Type -- Connection Resiliency -- Custom Connection Strategies -- Building the Base Entity Class -- Entity Framework Conventions.

Data Annotations Support in EF CoreAdding Data Annotations to the EntityBase Class -- Adding the Category Model Class -- Adding the Categories DbSet -- Migrations -- Executing EF .NET CLI Commands -- Creating the First Migration -- Removing a Migration -- Applying the Migration -- Viewing the Database -- Creating Migration SQL Scripts -- Understanding CRUD Operations Using Entity Framework -- Creating Records -- Reading Records -- No-Tracking Queries -- Updating Records -- Concurrency Checking -- Updating Using Entity State -- Deleting Records -- Deleting Using Entity State -- Unit Testing EF Core.

Creating the CategoryTests ClassCreating and Running the First Test -- Testing EF CRUD Operations -- Test Adding a Category Record -- Test Retrieving All Category Records -- Test Updating a Category Record -- Test Deleting a Category Record Using Remove -- Test Deleting a Record Using EntityState -- Testing Concurrency Checking -- Adding the Core Repository Interface and Base Class -- Adding the IRepo Interface -- Adding the Base Repository -- Adding the Category Repository -- Summary -- Chapter 2: Building the Data Access Layer with Entity Framework Core -- The SpyStore Database -- Navigation Properties and Foreign Keys.

Handling Display NamesMixing EF with Stored Procedures and Functions -- Finishing the Model Classes -- Updating the Category Model -- Adding the Product Model -- Adding the Shopping Cart Record Model -- Adding the Order Model -- Adding the Order Detail Model -- Adding the Customer Model -- Updating the StoreContext -- Adding the DbSet Properties for the Models -- Finishing the Model with the Fluent API -- Creating the Unique Index for Email Addresses on the Customer Table -- Setting Default Values on the Order Table -- Creating the Computed Column for Order Details.

"Learn how to build web applications from three Microsoft MVPs. You will be able to compare and contrast several frameworks and select the best one for your needs. With the release of .NET Core and Visual Studio 2017, you can deploy applications to multiple operating systems. And with the rising popularity of JavaScript UI frameworks, you can choose whether to stay with ASP.NET Core MVC or use a JavaScript framework. Building Web Applications with Visual Studio 2017 shows you how to build a site in Core MVC, and the three most popular JavaScript frameworks: Angular 2, React, and Aurelia. What You Will Learn: * Build a data access layer with Entity Framework Core * Build a RESTful service with ASP.NET Core MVC * Build a website with ASP.NET Core MVC and Bootstrap * Build the same website in Angular 2, React, and Aurelia. Who This Book Is For: Intermediate to advanced .NET developers."--