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
  • Locked
    4. 
    Updating an Existing Database Entry
    3m 35s
  • Locked
    5. 
    Deleting an Existing Database Entry
    4m 2s
  • Locked
    6. 
    Connecting to a SQL Server Compact Database
    3m 34s
  • Locked
    7. 
    Connecting to a Windows Azure SQL Database
    3m 22s
  • Locked
    8. 
    Using the Entity Framework Database-First Workflow
    3m 29s
  • Locked
    9. 
    Using the Entity Framework Model-First Workflow
    3m 3s
  • Locked
    10. 
    Using the Entity Framework Code-First Workflow
    3m 42s
  • Locked
    11. 
    Using LINQ Queries with Method Syntax
    4m 30s
  • Locked
    12. 
    Using LINQ Queries with Method and Query Syntax
    3m 31s
  • Locked
    13. 
    Implementing a Repository Class
    3m 15s
  • Locked
    14. 
    Exercise: Use Entity Framework
    3m 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.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE