Entity Framework Core

0%
Coding
Theory
Quiz

    Entity Modeling Relationships

    • Configure Many-to-Many With Fluent API

      Junior

    • Map an Owned Address Type

      Junior

    • One-to-One User and UserProfile Mapping

      Junior

    • Composite Primary Key With Fluent API

      Junior

    • Many-to-Many With Join Entity

      Mid

    • TPH Inheritance With Discriminator Column

      Mid

    • Map Location Value Object With ComplexProperty

      Mid

    • Table-per-Type Inheritance Mapping

      Mid

    • Configure Cascade Delete Behavior

      Mid

    Query Performance Optimization

    • Read-Only Endpoint With AsNoTracking

      Junior

    • Eliminate N+1 With Include or Projection

      Mid

    • Generic IQueryable Pagination Extension

      Mid

    • Fix Cartesian Explosion With AsSplitQuery

      Senior

    • Eliminate Cartesian Explosion With Projection

      Senior

    • Keyset Cursor Pagination

      Senior

    Transactions Concurrency

    • Wrap Multiple SaveChanges in a Transaction

      Mid

    • Optimistic Concurrency With RowVersion

      Senior

    • Share a Transaction Across Two DbContexts

      Senior

    Interceptors Change Tracking

    • Auditing SaveChangesInterceptor for IAuditable

      Mid

    • Soft-Delete With Interceptor and Query Filter

      Senior

    • Slow Query Logging Command Interceptor

      Senior

    Property Mapping Conversion

    • Map a Property to a JSON Column

      Junior

    • Configure Unique and Composite Indexes

      Junior

    • JSON Value Converter for a Column

      Mid

    • Auto-Update LastUpdated Shadow Property

      Mid

    • Custom ValueConverters for Enum and List

      Mid

    • Shadow Property Ordering With EF.Property

      Mid

    • Computed Column and Default Value Mapping

      Mid

    Dynamic Raw Sql Queries

    • Dynamic IQueryable Search Composition

      Mid

    • Dynamic LINQ Filter From Expression Trees

      Senior

    • Raw SQL With CTE Mapped To Entity

      Senior

    Migrations Seeding

    • Idempotent Master Data Seeding

      Mid

    Querying Loading

    • Deep Eager Loading With Include/ThenInclude

      Junior

    • Filtered Include for In-Stock Products

      Junior

    • Projected Query Into a DTO

      Mid

    • Explicit Loading With Entry()

      Mid

    • GroupBy Aggregation Translated to SQL

      Mid

    Context Lifecycle Advanced Patterns

    • DbContext Pooling With Stateful Services

      Senior

    • Transactional Outbox With EF Core

      Senior

    • Fix Scoped DbContext in Background Service

      Senior

    Patterns Filters Bulk Operations

    • Soft Delete With Global Query Filter

      Mid

    • Generic Repository Over DbSet

      Mid

    • Bulk Price Increase With ExecuteUpdateAsync

      Mid

    • Map a Keyless Entity to a View

      Mid

    • Unit of Work With Single CommitAsync

      Mid

    • Generic Repository With Eager Loading

      Mid

    • Bulk Delete With ExecuteDeleteAsync

      Mid

    • Split Fluent Config Into Configuration Classes

      Mid

    • Enable Lazy Loading Proxies

      Mid

    • Multi-Tenant Isolation With Global Query Filters

      Senior