Osama Shnaikat

.NET Developer

.NET Development

Data Access in .NET: ADO.NET and Entity Framework

Master Data Access in .NET: Build, Query, and Manage Databases with ADO.NET and Entity Framework for Scalable Applications

28 Lesson

14h 22min

Overview
Course Description

The Complete .NET Data Access Course is designed to give you in-depth knowledge and practical skills for interacting with databases in .NET using both ADO.NET and Entity Framework Core. From executing SQL commands manually to building fully managed data models with EF Core, this course covers everything you need to develop robust, scalable, and real-world data-driven applications.

Whether you're working on small projects or enterprise-grade systems, you'll gain the tools to perform efficient database operations, apply modern data access techniques, and leverage powerful LINQ queries. With hands-on demos, tasks, and a final project, you'll reinforce what you learn by applying it to realistic scenarios.

By the end of the course, you'll confidently handle database interactions in .NET, write optimized queries, build practical solutions using both ADO.NET and EF Core.

  • Prerequisites:
    1. C# knowledge.
    2. LINQ with collections.
    3. Understanding of databases and SQL basics.
What you'll learn
  • ADO.NET
    1. Connect and interact with databases manually.
    2. Use ExecuteNonQuery, ExecuteScalar, and DataReader.
    3. Practice with a hands-on demo and task.
  • LINQ & Advanced Concepts
    1. Query data with LINQ in EF Core.
    2. Learn advanced LINQ and execution strategies.
    3. Compare IEnumerable vs IQueryable.
    4. Use lazy and eager loading.
    5. Build real-world queries and complete tasks.
  • Entity Framework Core (EF Core)
    1. Understand ORM and EF Core basics.
    2. Use Code-First and manage migrations.
    3. Work with the Database-First approach.
    4. Configure entities with Data Annotations and Fluent API.
    5. Define relationships and seed data.
    6. Perform CRUD operations with EF Core.
    7. Apply concepts through demos and tasks.
  • Real-World Applications
    1. Apply all concepts in practical scenarios and a projects.
Show more Show less

$50

$100

Enroll Now

Includes

  • Engaging Instructor
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Course Content
28 Lectures 14h 22min

  • Course Overview

    Preview 02:45

  • Visual Studio Installation Guide

    03:54

  • SQL Server Installation Guide

    04:22

  • Getting Started with ADO.NET

    Preview 01:34

  • ADO.NET: ExecuteNonQuery

    47:45

  • ADO.NET: ExecuteReader

    16:01

  • ADO.NET: ExecuteScalar

    07:58

  • Demo: Patient Record Manager (ADO.NET)

    01:07:07

  • Task: Student Record Manager (ADO.NET)

    01:43

  • Solution: Student Record Manager (ADO.NET)

    01:15:06

  • Introduction to EF Core and ORM Concepts

    Preview 14:07

  • Code-First Approach and Migrations

    01:13:32

  • Entity Configuration using Data Annotations

    21:31

  • Entity Configuration using Fluent API

    21:42

  • Defining Entity Relationships

    01:18:11

  • Database Seeding with EF Core

    14:32

  • Database-First Approach with EF Core

    22:21

  • Performing CRUD with EF Core

    58:40

  • Demo: Patient Record Manager (EF)

    38:24

  • Task: Student Record Manager (EF)

    00:51

  • Solution: Student Record Manager (EF)

    25:38

  • LINQ Recap & Using LINQ with Entity Framework

    18:01

  • Advanced LINQ with Entity Framework

    59:28

  • Advanced LINQ: IEnumerable vs IQueryable & Execution Strategies

    35:44

  • Entity Framework Loading Strategies: Lazy vs Eager

    35:25

  • Demo: LINQ Queries on Student Database

    01:08:31

  • Task: LINQ Queries on Clinic Database

    03:25

  • Solution: LINQ Queries on Clinic Database

    43:52
About the instructor
Osama Shnaikat

.NET Developer

A .NET Developer with 14+ years of experience in web development, I have developed and led numerous successful software projects and helped countless individuals master web development and build successful careers.

I specialize in both front-end and back-end technologies, including HTML, CSS, JavaScript, .NET, .NET Core, Angular, Bootstrap, SQL, APIs, cloud services, and more.

My goal is to ensure students understand how to manage, execute, and deliver successful projects in real-world environments, preparing them for success in the tech industry.