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
Specialty Areas
- Software Development
Feedback
If you would like to provide feedback for this course, please e-mail the NICCS SO at NICCS@hq.dhs.gov.