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
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