ASP.NET MVC Web Applications: Databases & Entity Framework

Visual Studio 2017    |    Intermediate
  • 14 Videos | 57m 27s
  • Includes Assessment
  • Earns a Badge
Likes 17 Likes 17
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 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

IN THIS COURSE

  • Playable
    1. 
    Seeding a SQL Server Express LocalDB Database
    3m 30s
    UP NEXT
  • Playable
    2. 
    Adding a New Database Entry
    3m 47s
  • Locked
    3. 
    Reading an Existing Database Entry
    3m 59s
    FREE ACCESS
  • Locked
    4. 
    Updating an Existing Database Entry
    3m 35s
    FREE ACCESS
  • Locked
    5. 
    Deleting an Existing Database Entry
    4m 2s
    FREE ACCESS
  • Locked
    6. 
    Connecting to a SQL Server Compact Database
    3m 34s
    FREE ACCESS
  • Locked
    7. 
    Connecting to a Windows Azure SQL Database
    3m 22s
    FREE ACCESS
  • Locked
    8. 
    Using the Entity Framework Database-First Workflow
    3m 29s
    FREE ACCESS
  • Locked
    9. 
    Using the Entity Framework Model-First Workflow
    3m 3s
    FREE ACCESS
  • Locked
    10. 
    Using the Entity Framework Code-First Workflow
    3m 42s
    FREE ACCESS
  • Locked
    11. 
    Using LINQ Queries with Method Syntax
    4m 30s
    FREE ACCESS
  • Locked
    12. 
    Using LINQ Queries with Method and Query Syntax
    3m 31s
    FREE ACCESS
  • Locked
    13. 
    Implementing a Repository Class
    3m 15s
    FREE ACCESS
  • Locked
    14. 
    Exercise: Use Entity Framework
    3m 39s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

COURSE Advanced Data Access with EF Core
Likes 4 Likes 4  
COURSE ASP.NET MVC Web Applications: Authorization & Exception Handling
Likes 20 Likes 20  
COURSE ASP.NET MVC Web Applications: Models & Unit Testing
Likes 19 Likes 19  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE ASP.NET MVC Web Applications: MVC Controllers & Actions
Likes 42 Likes 42  
COURSE ASP.NET MVC Web Applications: Designing Application Architecture
Likes 18 Likes 18  
COURSE Introduction to ASP.NET Core 1.0
Likes 17 Likes 17