ASP.NET MVC Web Applications: Databases & Entity Framework

Visual Studio 2017
  • 14 Videos | 57m 27s
  • Includes Assessment
  • Earns a Badge
Likes 14 Likes 14
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 ASP.NET MVC Web Applications: Host Options & WebApp Composition
Likes 9 Likes 9  
COURSE ASP.NET MVC Web Applications: Deployment Architecture
Likes 17 Likes 17  
COURSE Programming in C#: Implementing Data Access
Likes 29 Likes 29  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Developing Azure & Web Services: Entity Framework
Likes 13 Likes 13  
COURSE Introduction to SOLID
Likes 62 Likes 62  
COURSE ASP.NET MVC Web Applications: Web API Routes & Controllers
Likes 21 Likes 21