Full Stack Web Development, Hands-On Labs

HOL01 Full Day Hands-On Lab: Develop an ASP.NET Core 2 App with EF Core 2 in a Day

10/06/2019

9:00am - 6:00pm

Level: Intermediate

Philip Japikse

Microsoft MVP, ASPInsider, MCSD, PSM II, PSD and PST

Developer, Coach, Author, Teacher

Interested in ASP.NET Core 2.x and Entity Framework Core 2.x, but not sure where to start? Start here with an all-day Hands-on Lab where you will build a complete solution using the latest development technology from Microsoft. Using Visual Studio or Visual Studio Code and .NET Core 2.1 (or greater), you will build a data access library using Entity Framework Core, complete with repos and migrations. Next, you will build an ASP.NET Core web application, leveraging all of the latest that ASP.NET Core has to offer, including Tag Helpers, View Components, Dependency Injection, and more!

You will learn:

  • Use EF Core to build the data access layer
  • Use ASP.NET Core to build the web application
  • New features in EF Core and ASP.NET Core

Attendee Requirements:

  • You must provide your own laptop computer (Windows or Mac) for this hands-on lab.
  • You will need to have and IDE installed. Any one of the following will work (all available from: https://www.visualstudio.com/downloads/):
    • Visual Studio 2017 v15.9+ (any edition). When installing, make sure to select the "ASP.NET and web development" and ".NET Core cross-platform development" workloads.
    • Visual Studio 2019 (any edition) When installing, make sure to select the "ASP.NET and web development" and ".NET Core cross-platform development" workloads.
    • Visual Studio for the Max (v7.7+) When installing, make sure to select “.NET Core + ASP.Net Core”
    • Visual Studio Code (1.33.1+) After installing, make sure to add in the select the "C# for Visual Studio Code (powered by OmniSharp)" and "C# Extensions (jchannon)" extensions.
  • You will need to install the x64 versions of the .NET Core SDK and Runtime (2.1 and/or 2.2). They can be downloaded from https://www.microsoft.com/net/download/core. Confirm the install by opening a command prompt, enter "dotnet –list-sdks" (without the quotes) - you should see 2.1.603 (or greater) for version 2.1 and 2.2.203 (or greater)for version 2.2. Confirm the runtime by typing "dotnet --list-runtimes" (without the quotes) and look for 2.1.10 (or greater) for version 2.1 and 2.2.4 (or greater) for version 2.2.
  • You also will need to have either Docker or a version of SQL Server (Express or above) 2014 or later. Docker is preferred (and required if you are not on a Windows based OS). If you are running Windows 7, you will need to install SQL Server Express 2014.
    • Docker Desktop Community Edition is free, and can be installed from https://www.docker.com/get-started. Requires Windows 10 or above. Mac requires 2010 hardware or above, MacOS Sierra 10.12 and above.
    • If you need to install SQL Server Express you can install from here: https://www.hanselman.com/blog/DownloadSqlServerExpress.aspx (select the correct version. If Windows 7, select SQL Server Express 2014. If Windows 8 or Windows 10, install SQL Server Express 2016 or SQL Server Express 2017).
  • Finally, you need to have SQL Server Management Studio (SSMS) installed. SSMS can be installed from the SQL Server Express installer.