ASP.NET MVC Web Applications: Databases & Entity Framework
Visual Studio 2017
| Intermediate
- 14 Videos | 50m 57s
- Includes Assessment
- Earns a Badge
Discover how to create databases and administer access to model classes using Entity Framework.
WHAT YOU WILL LEARN
-
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 applicationuse MVC Scaffolding to create a controller with actions and views that can be used to add new records to a SQL Server Express databaseuse MVC Scaffolding to create a controller with actions and views that can be used to read existing records in a SQL Server Express databaseuse MVC Scaffolding to create a controller with actions and views that can be used to edit existing records in a SQL Server Express databaseuse MVC Scaffolding to create a controller with actions and views that can be used to delete existing records from a SQL Server Express databaseconnect an ASP.NET MVC web application to a SQL Server Compact 4.0 database in Visual Studio 2017connect 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 2017use the Entity Framework model-first approach to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017use 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 2017use 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 2017use 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 2017create 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 2017use Entity Framework to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017
IN THIS COURSE
-
1.Seeding a SQL Server Express LocalDB Database3m 30sUP NEXT
-
2.Adding a New Database Entry3m 47s
-
3.Reading an Existing Database Entry3m 59s
-
4.Updating an Existing Database Entry3m 35s
-
5.Deleting an Existing Database Entry4m 2s
-
6.Connecting to a SQL Server Compact Database3m 34s
-
7.Connecting to a Windows Azure SQL Database3m 22s
-
8.Using the Entity Framework Database-First Workflow3m 29s
-
9.Using the Entity Framework Model-First Workflow3m 3s
-
10.Using the Entity Framework Code-First Workflow3m 42s
-
11.Using LINQ Queries with Method Syntax4m 30s
-
12.Using LINQ Queries with Method and Query Syntax3m 31s
-
13.Implementing a Repository Class3m 15s
-
14.Exercise: Use Entity Framework3m 39s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.