ASP.NET MVC Web Applications: Databases & Entity Framework

Visual Studio 2017    |    Intermediate
  • 14 videos | 50m 57s
  • Includes Assessment
  • Earns a Badge
Likes 33 Likes 33
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

  • 3m 30s
    In this video, find out how to 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. FREE ACCESS
  • 3m 47s
    In this video, you will 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. FREE ACCESS
  • Locked
    3.  Reading an Existing Database Entry
    3m 59s
    In this video, learn how to use MVC Scaffolding to create a controller with actions and views that can be used to read, create, update, and delete records in a SQL Server Express database. FREE ACCESS
  • Locked
    4.  Updating an Existing Database Entry
    3m 35s
    In this video, learn how to use MVC Scaffolding to create a controller with actions and views that can edit existing records in a SQL Server Express database. FREE ACCESS
  • Locked
    5.  Deleting an Existing Database Entry
    4m 2s
    Learn how to 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. FREE ACCESS
  • Locked
    6.  Connecting to a SQL Server Compact Database
    3m 34s
    In this video, find out how to connect an ASP.NET MVC web application to a SQL Server Compact 4.0 database in Visual Studio 2017. FREE ACCESS
  • Locked
    7.  Connecting to a Windows Azure SQL Database
    3m 22s
    In this video, you will learn how to connect an ASP.NET MVC web application to a Windows Azure SQL database using Visual Studio 2017. FREE ACCESS
  • Locked
    8.  Using the Entity Framework Database-First Workflow
    3m 29s
    During this video, you will learn how to 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. FREE ACCESS
  • Locked
    9.  Using the Entity Framework Model-First Workflow
    3m 3s
    During this video, you will learn how to use the Entity Framework model-first approach to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017. FREE ACCESS
  • Locked
    10.  Using the Entity Framework Code-First Workflow
    3m 42s
    Learn how to 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. FREE ACCESS
  • Locked
    11.  Using LINQ Queries with Method Syntax
    4m 30s
    In this video, learn how to 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. FREE ACCESS
  • Locked
    12.  Using LINQ Queries with Method and Query Syntax
    3m 31s
    In this video, learn how to 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. FREE ACCESS
  • Locked
    13.  Implementing a Repository Class
    3m 15s
    In this video, you will create a data repository class, and use that data repository class to implement data management logic in an ASP.NET MVC web application in Visual Studio 2017. FREE ACCESS
  • Locked
    14.  Exercise: Use Entity Framework
    3m 39s
    In this video, learn how to use Entity Framework to generate a SQL Server database in an ASP.NET MVC web application in Visual Studio 2017. 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel SQL Database Development & Design
Likes 316 Likes 316  
Book Creating ASP.NET Core Web Applications: Proven Approaches to Application Design and Development
Channel Wintellect ASP.NET
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course ASP.NET MVC Web Applications: MVC Controllers & Actions
Likes 68 Likes 68  
Course ASP.NET MVC Web Applications: Models & Unit Testing
Likes 32 Likes 32  
Course ASP.NET MVC Web Applications: Adaptive UI Layout & Caching Strategy
Likes 19 Likes 19