Entity Framework: Building Real-World Applications

Learn to build scalable and efficient applications with Entity Framework by working on real-world projects

What you'll learn

Understanding and applying Entity Framework concepts, including code-first models and migrations.

How to implement CRUD operations and data validation using EF.

Advanced querying techniques with LINQ, Entity SQL, and raw SQL.

How to design and implement complex relationships between tables in a database.

Creating real-world projects such as a Hospital Management System and Employee List Manager.

By the end of this course, you’ll be ready to work on large-scale applications, utilizing Entity Framework to manage complex data structures

Requirements

Basic knowledge of C# and object-oriented programming. Familiarity with databases and SQL (though not mandatory). A working installation of Visual Studio and SQL Server (or any compatible database).

Description

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 SystemThis 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 ProjectYou’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 FrameworkThis lecture covers the basics of Entity Framework, including its core concepts and how it simplifies database operations with C#.Lecture 3: Patient ClassYou will learn how to define the Patient class, which represents patient data, and map it to the database using EF.Lecture 4: Hospital ContextThe HospitalContext class will be introduced, serving as the bridge between your application and the database, enabling CRUD operations.Lecture 5: Using VarUnderstanding how to use var in C# for implicit type declaration, especially when querying data using EF.Lecture 6: Table ChangeLearn how to modify table schemas, including adding or removing columns, and ensuring your model and database remain in sync.Lecture 7: Protected Override VoidThis lecture introduces overriding protected methods for customizing behavior in your EF models.Lecture 8: Schema Defining and TableYou’ll explore schema definitions and how to create tables based on the DbContext configuration.Lecture 9: Fluent APILearn how to use Fluent API to configure your Entity Framework models in more advanced ways than data annotations allow.Lecture 10: StatementIntroduction to writing EF queries using LINQ or method syntax to retrieve and manipulate data.Lecture 11: Data DoneThis lecture summarizes how to persist data changes to the database after performing CRUD operations.Lecture 12: Overview of Patient DetailsYou’ll review the details of the Patient class and its properties, making sure all required fields are properly configured.Lecture 13: Changing the Column SizeLearn how to modify the size of columns in your database when necessary, adjusting your data model accordingly.Lecture 14: Setting the Text SizeYou’ll explore how to set the text length for string properties in your model.Lecture 15: Medicine IDLearn how to handle relationships between patients and medications in your system, using foreign keys and navigation properties.Lecture 16: Data AnnotationsYou’ll understand how data annotations are used to define validation rules and schema information directly in your models.Lecture 17: CUD OperationsThis lecture focuses on performing Create, Update, and Delete operations with Entity Framework.Lecture 18: ProgramYou’ll begin integrating your code into a complete program, running the Hospital Management System as a working application.Lecture 19: Hospital DB InitializerLearn how to set up your database initializer to seed your database with initial data upon creation.Lecture 20: DB Model BuilderA deeper dive into building your database model using EF's code-first approach.Section 2: Project on Entity Framework: Managing Employee ListIn 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 ProjectThis lecture introduces the goals of the Employee List project, focusing on managing employee data efficiently using EF.Lecture 22: Entity FrameworkA refresher on how Entity Framework works and how it simplifies database interaction for applications.Lecture 23: Graph TableLearn how to create graph tables for managing complex relationships like employees and their respective departments.Lecture 24: Department Table CreationThis lecture guides you through setting up the department table, which will relate to employee records.Lecture 25: Small Correction and VSFix minor issues and learn troubleshooting tips in Visual Studio during development.Lecture 26: VS Side ExplanationA look at the Visual Studio tools and settings used to build Entity Framework applications.Lecture 27: CRUD OperationsIntroduction to performing CRUD operations (Create, Read, Update, Delete) with Entity Framework on employee records.Lecture 28: Insert Into Dept and Dept SuccessLearn how to insert new records into the department table and validate that the insertion was successful.Lecture 29: EMP InsertThis lecture focuses on inserting new employee records into the database.Lecture 30: Emp Success and SkillSet InsertContinuing the employee management, you’ll learn how to insert skillset information and confirm success.Lecture 31: Skillset Success To Delete SuccessFocus on deleting records from the database, such as removing an employee or skillset, while ensuring referential integrity.Lecture 32: Introduction to Query MechanismLearn the basics of querying data using LINQ and Entity Framework.Lecture 33: Select LINQ QueryGet hands-on experience with writing Select LINQ queries to retrieve employee data.Lecture 34: Select LINQ MethodYou’ll learn the method syntax of LINQ to achieve the same result as the query syntax.Lecture 35-36: WHERE LINQ Query & MethodUnderstand how to filter data with Where queries using both query and method syntax in LINQ.Lecture 37-40: Working with Lists and OrderingLearn to work with lists of data, order results, and apply multiple sorting criteria using LINQ.Lecture 41-44: Grouping, Finding, and ProjectionsThese lectures cover how to group data, find specific records, and project results to custom formats.Lecture 45-46: First Default & Entity SQLLearn to retrieve the first record, handle default values, and start working with Entity SQL for more complex queries.Lecture 47-56: Advanced Querying & Raw SQLDelve 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.

Overview

Section 1: Project on Entity Framework: Hospital Management System

Lecture 1 Introduction to Project

Lecture 2 Entity Framework

Lecture 3 Patient Class

Lecture 4 Hospital Context

Lecture 5 Using Var

Lecture 6 Table Change

Lecture 7 Protected Override Void

Lecture 8 Schema Definig and Table

Lecture 9 Fluent API

Lecture 10 Statement

Lecture 11 Data Done

Lecture 12 Overview Patient Details

Lecture 13 Changing the Column Size

Lecture 14 Setting the Text Size

Lecture 15 Medicine ID

Lecture 16 Data Annotations

Lecture 17 CUD Operations

Lecture 18 Programe

Lecture 19 Hospital DB Initialiser

Lecture 20 DB Model Builder

Section 2: Project on Entity Framework: Managing Employee List

Lecture 21 Introduction to Project

Lecture 22 Entity Framwork

Lecture 23 Graph Table

Lecture 24 Department Table Creation

Lecture 25 Small Correction and VS

Lecture 26 VS Side Explanation

Lecture 27 Crud

Lecture 28 Insert Into Dept and Dept Success

Lecture 29 EMP Insert

Lecture 30 Emp Success and SkillSet Insert

Lecture 31 Skillset Success To delete Success

Lecture 32 Introduction to Query Mech

Lecture 33 Select LINQ Query

Lecture 34 Select LINQ Method

Lecture 35 WHERE LINQ Q and LINQ Q Success

Lecture 36 WHERE LIN Methd and LINQ M Success

Lecture 37 Introduction to List

Lecture 38 LIST Q and Success

Lecture 39 LIST M Syntax and TLIST M Success

Lecture 40 Order By Query

Lecture 41 Order By Multiple Fields

Lecture 42 Order By Method

Lecture 43 Group By QSucces

Lecture 44 Find and Find Null

Lecture 45 First Default Method

Lecture 46 Projection Query

Lecture 47 Link Query

Lecture 48 Projection Custom

Lecture 49 Custom Employe Details

Lecture 50 Introduction to Entity SQL

Lecture 51 Entity SQL Success

Lecture 52 Raw SQL

Lecture 53 DB Set SQL

Lecture 54 Database SQL

Lecture 55 Database Exec SQL

Lecture 56 Conclusion

Intermediate developers looking to expand their knowledge of Entity Framework and database management.,Software developers who want to learn how to use EF for building enterprise-level applications.,Anyone interested in mastering EF to build scalable and maintainable web applications using C#.