Developing Azure & Web Services: Entity Framework

Visual Studio 2017
  • 22 Videos | 2h 7m 13s
  • Includes Assessment
  • Earns a Badge
Likes 13 Likes 13
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
    UP NEXT
  • Playable
    2. 
    Creating and Configuring an Entity DB Context
    4m 2s
  • Locked
    3. 
    Using Entity Data Annotations
    3m 38s
  • Locked
    4. 
    Describing Entity Type Inheritance
    3m 42s
  • Locked
    5. 
    Using Type Inheritance
    4m 57s
  • Locked
    6. 
    Working with Data Modeling
    3m 7s
  • Locked
    7. 
    Define Language Integrated Query (LINQ)
    4m 12s
  • Locked
    8. 
    Using LINQ to Entities to Query a Database
    5m 45s
  • Locked
    9. 
    Performing Queries Using Entity SQL
    3m 33s
  • Locked
    10. 
    Building Queries That Use Deferred Execution
    2m 52s
  • Locked
    11. 
    Implementing Lazy Loading and Eager Loading
    10m 29s
  • Locked
    12. 
    Creating and Running Compiled Queries
    6m 31s
  • Locked
    13. 
    Executing SQL Queries Directly
    4m 22s
  • Locked
    14. 
    Performing CRUD Operations Using Entity
    3m 49s
  • Locked
    15. 
    Using Change Tracking with Entity
    4m 20s
  • Locked
    16. 
    Using Transactions with Entity
    3m 19s
  • Locked
    17. 
    Logging Queries and DB Commands
    4m 39s
  • Locked
    18. 
    Implementing Entity Framework Using MySQL
    17m 32s
  • Locked
    19. 
    Implementing Entity Framework Using SQLite
    10m 53s
  • Locked
    20. 
    Designing Strategy to Target Multiple Databases
    3m 11s
  • Locked
    21. 
    Handling ON DUPLICATE KEY
    3m 18s
  • Locked
    22. 
    Exercise: Model Data with Entity
    4m 50s

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

Likes 13 Likes 13