Entity Framework Core 2.0 Training in Marina Bay, Singapore

This course introduces Entity Framework Core 2.0 (EF Core 2.0), Microsoft’s modern Object-Relational Mapper (ORM) for .NET applications. Participants will learn how to use EF Core to model data, perform queries, manage relationships, handle migrations, and optimize database operations. The course emphasizes practical implementation through coding exercises and real-world scenarios.

Introduction & Basics

• Introduction to EF Core 2.0

  • What’s new compared to EF 6

  • Supported databases and providers

• Setting up EF Core

  • Installation via NuGet

  • Project setup with .NET Core

• Data Modeling

  • Entities, properties, and keys

  • Code-First approach

  • Database-First approach with scaffolding

• DbContext & DbSet

Querying & Relationships

• LINQ Queries with EF Core

  • Filtering, sorting, grouping

  • Loading related data (eager, lazy, explicit)

• CRUD Operations

  • Insert, update, delete, and save changes

• Relationships

  • One-to-One, One-to-Many, Many-to-Many

  • Navigation properties and foreign keys

• EF Core Migrations

  • Creating and applying migrations

  • Schema updates and rollback

Advanced Features & Best Practices

• Concurrency & Transactions

  • Handling optimistic concurrency

  • Using transactions and SaveChanges()

• Performance Optimization

  • Tracking vs No-Tracking queries

  • Compiled queries

  • Batching and caching

• Limitations and Workarounds in EF Core 2.0

• Best Practices

Hands-on Exercises

Summary and Conclusion