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