• Online, Self-Paced
Course Description

In this course, you will learn how to create databases and administer access to model classes using Entity Framework.

Learning Objectives

Working with Databases

  • start the course
  • use a database initializer class with Entity Framework 6 to create and seed a SQL Server Express database with sample data in an ASP.NET MVC web application
  • use MVC Scaffolding to create a controller with actions and views that can be used to add new records to a SQL Server Express database
  • use MVC Scaffolding to create a controller with actions and views that can be used to read existing records in a SQL Server Express database
  • use MVC Scaffolding to create a controller with actions and views that can be used to edit existing records in a SQL Server Express database
  • use MVC Scaffolding to create a controller with actions and views that can be used to delete existing records from a SQL Server Express database
  • connect an ASP.NET MVC web application to a SQL Server Compact 4.0 database in Visual Studio 2017
  • connect an ASP.NET MVC web application to a Windows Azure SQL database in Visual Studio 2017

Working with Entity Framework and LINQ

  • use the Entity Framework database-first approach to produce MVC models, controllers, and views from a connected SQL Server Compact 4.0 database in an ASP.NET MVC web application in Visual Studio 2017
  • use the Entity Framework model-first approach to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017
  • use the Entity Framework code-first approach to generate a SQL Server Express database from an MVC model class in an ASP.NET MVC web application in Visual Studio 2017
  • use a LINQ to Entities query with method syntax to retrieve data from a connected SQL Server Compact 4.0 database in an ASP.NET MVC web application in Visual Studio 2017
  • use a LINQ to Entities query with a combination of method and query syntax to retrieve data from a connected SQL Server Compact 4.0 database in an ASP.NET MVC web application in Visual Studio 2017
  • create a data repository class, and use a data repository class to implement data management logic in an ASP.NET MVC web application in Visual Studio 2017

Practice: Using Entity Framework

  • use Entity Framework to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.

Feedback

If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.