Developing Azure & Web Services: Entity Framework

Visual Studio 2017    |    Expert
  • 22 videos | 1h 56m 43s
  • Includes Assessment
  • Earns a Badge
Likes 17 Likes 17
Entity Framework is an object relational mapper (ORM) and uses an object-oriented representation for data. Explore Entity and the operations it provides to make working with data easier.

WHAT YOU WILL LEARN

  • describe the need for object relational mappers and the development approaches including database first, model first, and code first
    create and configure a DBContext and query the database using the DBContext class
    use Data Annotations to manually map classes to database schema objects
    describe the Entity methods for mapping an OOP environment to database tables
    use the Fluent API to map classes to tables
    work with data model schema definition languages to model data
    define LINQ and how it interacts with SQL and Entity
    use LINQ to Entities to query a database
    perform a query against a database using Entity SQL
    build a query that uses deferred execution
    implement lazy loading and eager loading
  • creating and running compiled queries
    execute SQL statements directly using Entity and return objects or scalar values
    perform Create, Read, Update, and Delete operations using Entity
    use Change Tracking with Entity to monitor if an object has changed
    use Transactions and the TransactionScope class to group operations
    log and track queries and commands sent to a database
    implement Entity Framework using MySQL
    implement Entity Framework using SQLite
    designing strategy to target multiple databases
    handling ON DUPLICATE KEY
    manipulate data and data models using the Entity Framework

IN THIS COURSE

  • Playable
    1.  Describing the Entity Framework Data Model
    3m 43s
    Upon completion of this video, you will be able to describe the need for object relational mappers and the development approaches including database first, model first, and code first. FREE ACCESS
  • Playable
    2.  Creating and Configuring an Entity DB Context
    4m 2s
    Learn how to create and configure a DBContext and query the database using the DBContext class. FREE ACCESS
  • Locked
    3.  Using Entity Data Annotations
    3m 38s
    In this video, learn how to use Data Annotations to map classes to database schema objects manually. FREE ACCESS
  • Locked
    4.  Describing Entity Type Inheritance
    3m 42s
    After completing this video, you will be able to describe the Entity methods for mapping an OOP environment to database tables. FREE ACCESS
  • Locked
    5.  Using Type Inheritance
    4m 57s
    In this video, learn how to map classes to tables using the Fluent API. FREE ACCESS
  • Locked
    6.  Working with Data Modeling
    3m 7s
    Find out how to work with data model schema definition languages to create models of data. FREE ACCESS
  • Locked
    7.  Define Language Integrated Query (LINQ)
    4m 12s
    In this video, you will learn about LINQ and how it interacts with SQL and Entity. FREE ACCESS
  • Locked
    8.  Using LINQ to Entities to Query a Database
    5m 45s
    In this video, you will learn how to use LINQ to Entities to query a database. FREE ACCESS
  • Locked
    9.  Performing Queries Using Entity SQL
    3m 33s
    In this video, find out how to query a database using Entity SQL. FREE ACCESS
  • Locked
    10.  Building Queries That Use Deferred Execution
    2m 52s
    In this video, find out how to build a query that uses lazy evaluation. FREE ACCESS
  • Locked
    11.  Implementing Lazy Loading and Eager Loading
    10m 29s
    Find out how to implement lazy loading and eager loading. FREE ACCESS
  • Locked
    12.  Creating and Running Compiled Queries
    6m 31s
    In this video, find out how to create and run compiled queries. FREE ACCESS
  • Locked
    13.  Executing SQL Queries Directly
    4m 22s
    Learn how to execute SQL statements directly using Entity and return either objects or scalar values. FREE ACCESS
  • Locked
    14.  Performing CRUD Operations Using Entity
    3m 49s
    During this video, you will learn how to perform Create, Read, Update, and Delete operations using Entity Framework. FREE ACCESS
  • Locked
    15.  Using Change Tracking with Entity
    4m 20s
    To find out how to use Change Tracking with Entity, look for a tutorial or article that explains the process. FREE ACCESS
  • Locked
    16.  Using Transactions with Entity
    3m 19s
    Find out how to use Transactions and the TransactionScope class to group operations. FREE ACCESS
  • Locked
    17.  Logging Queries and DB Commands
    4m 39s
    Learn how to log and track queries and commands sent to a database. FREE ACCESS
  • Locked
    18.  Implementing Entity Framework Using MySQL
    17m 32s
    Find out how to implement Entity Framework using MySQL. FREE ACCESS
  • Locked
    19.  Implementing Entity Framework Using SQLite
    10m 53s
    In this video, learn how to use Entity Framework with SQLite. FREE ACCESS
  • Locked
    20.  Designing Strategy to Target Multiple Databases
    3m 11s
    During this video, you will learn how to design a strategy to target multiple databases. FREE ACCESS
  • Locked
    21.  Handling ON DUPLICATE KEY
    3m 18s
    Learn how to handle ON DUPLICATE KEY. FREE ACCESS
  • Locked
    22.  Exercise: Model Data with Entity
    4m 50s
    In this video, you will learn how to manipulate data and data models using the Entity Framework. 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

Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE