Entity Framework: Building Real-World Applications

Introduction:

The Entity Framework: Building Real-World Applications course provides a hands-on, practical approach to understanding Entity Framework (EF) through two major projects. You’ll learn how to model real-world data using EF, perform CRUD operations, and work with LINQ and SQL queries. By the end of this course, you’ll be proficient in using Entity Framework to build robust applications in .NET, with a focus on managing hospital data and employee lists.

Section 1: Project on Entity Framework: Hospital Management System

This section will guide you through building a Hospital Management System using Entity Framework. You will learn how to model the hospital’s data structure and manage patient information effectively.

• Lecture 1: Introduction to Project
  You’ll be introduced to the scope and objectives of the Hospital Management System project, including an overview of the hospital’s data needs and how Entity Framework will help manage it.
• Lecture 2: Entity Framework
  This lecture covers the basics of Entity Framework, including its core concepts and how it simplifies database operations with C#.
• Lecture 3: Patient Class
  You will learn how to define the Patient class, which represents patient data, and map it to the database using EF.
• Lecture 4: Hospital Context
  The HospitalContext class will be introduced, serving as the bridge between your application and the database, enabling CRUD operations.
• Lecture 5: Using Var
  Understanding how to use var in C# for implicit type declaration, especially when querying data using EF.
• Lecture 6: Table Change
  Learn how to modify table schemas, including adding or removing columns, and ensuring your model and database remain in sync.
• Lecture 7: Protected Override Void
  This lecture introduces overriding protected methods for customizing behavior in your EF models.
• Lecture 8: Schema Defining and Table
  You’ll explore schema definitions and how to create tables based on the DbContext configuration.
• Lecture 9: Fluent API
  Learn how to use Fluent API to configure your Entity Framework models in more advanced ways than data annotations allow.
• Lecture 10: Statement
  Introduction to writing EF queries using LINQ or method syntax to retrieve and manipulate data.
• Lecture 11: Data Done
  This lecture summarizes how to persist data changes to the database after performing CRUD operations.
• Lecture 12: Overview of Patient Details
  You’ll review the details of the Patient class and its properties, making sure all required fields are properly configured.
• Lecture 13: Changing the Column Size
  Learn how to modify the size of columns in your database when necessary, adjusting your data model accordingly.
• Lecture 14: Setting the Text Size
  You’ll explore how to set the text length for string properties in your model.
• Lecture 15: Medicine ID
  Learn how to handle relationships between patients and medications in your system, using foreign keys and navigation properties.
• Lecture 16: Data Annotations
  You’ll understand how data annotations are used to define validation rules and schema information directly in your models.
• Lecture 17: CUD Operations
  This lecture focuses on performing Create, Update, and Delete operations with Entity Framework.
• Lecture 18: Program
  You’ll begin integrating your code into a complete program, running the Hospital Management System as a working application.
• Lecture 19: Hospital DB Initializer
  Learn how to set up your database initializer to seed your database with initial data upon creation.
• Lecture 20: DB Model Builder
  A deeper dive into building your database model using EF’s code-first approach.

Section 2: Project on Entity Framework: Managing Employee List

In this section, you’ll develop a Managing Employee List system, allowing you to practice working with complex data models and managing employee records, including CRUD operations and querying.

• Lecture 21: Introduction to Project
  This lecture introduces the goals of the Employee List project, focusing on managing employee data efficiently using EF.
• Lecture 22: Entity Framework
  A refresher on how Entity Framework works and how it simplifies database interaction for applications.
• Lecture 23: Graph Table
  Learn how to create graph tables for managing complex relationships like employees and their respective departments.
• Lecture 24: Department Table Creation
  This lecture guides you through setting up the department table, which will relate to employee records.
• Lecture 25: Small Correction and VS
  Fix minor issues and learn troubleshooting tips in Visual Studio during development.
• Lecture 26: VS Side Explanation
  A look at the Visual Studio tools and settings used to build Entity Framework applications.
• Lecture 27: CRUD Operations
  Introduction to performing CRUD operations (Create, Read, Update, Delete) with Entity Framework on employee records.
• Lecture 28: Insert Into Dept and Dept Success
  Learn how to insert new records into the department table and validate that the insertion was successful.
• Lecture 29: EMP Insert
  This lecture focuses on inserting new employee records into the database.
• Lecture 30: Emp Success and SkillSet Insert
  Continuing the employee management, you’ll learn how to insert skillset information and confirm success.
• Lecture 31: Skillset Success To Delete Success
  Focus on deleting records from the database, such as removing an employee or skillset, while ensuring referential integrity.
• Lecture 32: Introduction to Query Mechanism
  Learn the basics of querying data using LINQ and Entity Framework.
• Lecture 33: Select LINQ Query
  Get hands-on experience with writing Select LINQ queries to retrieve employee data.
• Lecture 34: Select LINQ Method
  You’ll learn the method syntax of LINQ to achieve the same result as the query syntax.
• Lecture 35-36: WHERE LINQ Query & Method
  Understand how to filter data with Where queries using both query and method syntax in LINQ.
• Lecture 37-40: Working with Lists and Ordering
  Learn to work with lists of data, order results, and apply multiple sorting criteria using LINQ.
• Lecture 41-44: Grouping, Finding, and Projections
  These lectures cover how to group data, find specific records, and project results to custom formats.
• Lecture 45-46: First Default & Entity SQL
  Learn to retrieve the first record, handle default values, and start working with Entity SQL for more complex queries.
• Lecture 47-56: Advanced Querying & Raw SQL
  Delve into more advanced queries with Entity SQL and raw SQL commands to interact with the database directly.

Conclusion:

By completing Entity Framework: Building Real-World Applications, you will gain hands-on experience with Entity Framework, covering everything from basic CRUD operations to advanced query techniques. You’ll be able to confidently build and maintain real-world applications using Entity Framework, such as hospital management systems and employee tracking applications.