ASP.NET MVC Databases and Entity Framework


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



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

Target Audience
Web developers seeking an introductory guide to developing efficient, secure, distributed web applications with adaptive user interfaces using the ASP.NET MVC and MVC 5 frameworks in Visual Studio 2017, and individuals preparing for exam 70-486: Developing ASP.NET MVC Web Applications

Prerequisites
None

Expected Duration (hours)
0.9

Lesson Objectives

ASP.NET MVC Databases and Entity Framework

  • 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
  • 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
  • use Entity Framework to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017
  • Course Number:
    wd_dmvc_a05_it_enus

    Expertise Level
    Intermediate