Course Details

Previous Page


ASP.NET MVC Databases and the Entity Framework


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



Overview/Description
Databases and the Entity Framework add a great deal of value to any MVC application, as they allow the application to manage and interact with data. In this course, you will learn how to create databases and administer access to model classes using Entity Framework. This course is one of a series in the Skillsoft learning path that covers the objectives for the Microsoft MCSD exam 70-486.

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

Prerequisites
none

Expected Duration (hours)
2.5

Lesson Objectives

ASP.NET MVC Databases and the 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 2013
  • connect an ASP.NET MVC web application to a Windows Azure SQL database in Visual Studio 2013
  • 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 2013
  • use the Entity Framework model-first approach to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2013
  • 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 2013
  • 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 2013
  • 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 2013
  • create a data repository class; use a data repository class to implement data management logic in an ASP.NET MVC web application in Visual Studio 2013
  • understand concepts in implementing application state management, using asynchronous tasks and web sockets, and designing distributed systems
  • Course Number:
    wd_dwap_a04_it_enus