Entity Framework Core Syllabus

 ABFIRST Pvt Ltd        

    eNTITY FRAMEWORK

                Basics

§  Understanding ORM (Object-Relational Mapping)

§  Introduction to EF Core features and benefits

§  Installing EF Core via NuGet

§  Setting up a new project with EF Core

§  Creating and configuring a DbContext

§  Defining entity classes and relationships

§  Performing basic CRUD operations

   Querying Data

§  Using LINQ queries with EF Core

§  Understanding IQueryable and deferred execution

§  Filtering, sorting, and projecting data

§  Eager loading vs. lazy loading

§  Using Include, ThenInclude, and Select

§  Working with raw SQL queries

§  Using stored procedures with EF Core

   Working with Relationships

§  Configuring one-to-one relationships

§  Configuring one-to-many and many-to-one relationships

§  Configuring many-to-many relationships

§  Handling navigation properties

§  Eager loading with Include method

§  Lazy loading and explicit loading

   Entity States and CRUD Operations

§  Understanding entity states (Added, Unchanged, Modified, Deleted)

§  Adding new entities

§  Updating existing entities

§  Deleting entities

§  Saving changes to the database

§  Detaching and attaching entities

   Migrations and Database Schema Management

§  Enabling EF Core Migrations

§  Creating and applying migrations

§  Reverting migrations

§  Generating SQL scripts

§  Managing database schema changes

   Advanced Topics

§  Working with stored procedures

§  Working with Views

§  Implementing Domain-Driven Design (DDD) patterns

§  Unit of Work and Repository pattern with EF Core

§  Data seeding techniques

§  Using Value Conversions and Query Types

§  Integrating with ASP.NET Core

§  Implementing data access security measures

§  Integrating EF Core with authentication systems

§  Preventing common security vulnerabilities (e.g., SQL injection)

§  Logging EF Core operations

§  Debugging EF Core queries and operations

   Best Practices and Code Patterns

§  Applying SOLID principles to EF Core applications

§  Design patterns for EF Core applications

§  Coding standards and best practices

§  Identifying and resolving common issues in EF Core

§  Troubleshooting performance problems