Entity Framework 6 Training

Level

Advanced

Duration

16h / 2 days

Date

Individually arranged

Price

Individually arranged

Entity Framework 6 Training

The Entity Framework platform allows developers to work with data as domain-specific objects and properties, such as customers and customer addresses, without the need to directly manipulate the underlying database tables and columns where the data is stored. During the Entity Framework 6 training, you will learn many important aspects of this ORM (Object-Relational Mapping) framework and how to effectively use it in your projects.

What will you learn?

  • Gain practical knowledge of Entity Framework 6 as an ORM tool for effective database interaction in C#/.NET.
  • Understand what’s new in EF6 and the differences between EF6 and EF Core, enabling you to choose the right tool for your projects.
  • Learn to apply asynchronous operations and testing in Entity Framework to improve performance and application quality.
  • Master performance optimization techniques for read and write operations, addressing common issues such as N+1 queries and transactions.
  • Explore advanced topics including diagnostics, external libraries, and the benefits of migrating to EF Core.
Who is this training for?
  • logo infoshare For professionals working with databases who need a powerful tool for quick and convenient access to data.
  • logo infoshare For those learning C#/.NET programming – understanding EF6 helps in grasping how ORM works and how to use databases in applications.
  • logo infoshare For developers of business, web, and desktop applications requiring efficient database access.

Training Program

  1. Entity Framework – How It Works

  • Key aspects of EF crucial for optimization
  1. EF6 – What’s New Compared to Previous Versions

  • Overview of the changes introduced in version 6
  1. EF6 vs EF Core – Differences and Similarities

  • What’s important to know when comparing EF6 with EF Core
  1. Asynchronous Programming

  • Why async is a big step forward in ORM and database operations
  • Gains and costs of using this approach
  1. Testing with Entity Framework

  • Writing various types of tests using EF:
    • Unit tests
    • Load tests
    • Others
  1. Diagnostics

  • Mechanisms and tools for diagnosing problems at different levels (ORM, database queries, etc.)
  1. Queries and Performance – Part 1

  • Performance considerations for data read operations
  • Avoiding pitfalls:
    • N+1 problem
    • Client vs. server evaluation
    • Lazy vs. eager loading
    • Projections
    • Cold vs. warm queries
    • ngen
  1. Queries and Performance – Part 2

  • Continuation of read operation performance optimization with more examples
  1. Performance in Insert/Update/Delete Operations

  • Optimizing data modification operations, including handling large batches of changes
  1. Transactions – Problems and Solutions

  • Addressing issues such as deadlocks, race conditions, etc.
  1. External Libraries Worth Knowing

  • Useful open-source and commercial solutions that extend EF capabilities or database communication
  1. EF Core Advantages Over EF6 (Bonus Topic)

  • Benefits exclusive to EF Core not available in EF6
  • Migration considerations and scenarios

Contact us

we will organize training for you tailored to your needs

Przemysław Wołosz

Key Account Manager

przemyslaw.wolosz@infoShareAcademy.com

    The controller of your personal data is InfoShare Academy Sp. z o.o. with its registered office in Gdańsk, al. Grunwaldzka 427B, 80-309 Gdańsk, KRS: 0000531749, NIP: 5842742121. Personal data are processed in accordance with information clause.