---

Entity Framework (EF)

---

What is Entity Framework?

Entity Framework (EF) is an Object-Relational Mapper (ORM) for .NET.

It allows developers to work with a database using C# classes instead of writing SQL queries manually.

---

Simple Definition

Entity Framework helps us:

✔ Connect to Database
✔ Insert Data
✔ Update Data
✔ Delete Data
✔ Retrieve Data

Using C# code instead of SQL.

---

Why Do We Use Entity Framework?

• Reduces SQL coding
• Saves development time
• Automatically maps tables to classes
• Easy CRUD operations
• Best for real-world applications

---

Real-Life Example

Imagine you want to talk to a person who speaks another language.

• You speak English (C#)
• Database speaks SQL
• Entity Framework acts as a Translator

So you write C# code → EF converts it into SQL → Database understands it.

---

How Entity Framework Works

Database Table → EF Model Class → DbContext → Application

---

CRUD Operations in EF

• Create → Add()
• Read → ToList()
• Update → Modify object + SaveChanges()
• Delete → Remove()

---

Types of Entity Framework

• 1️⃣ Database First
• 2️⃣ Code First
• 3️⃣ Model First

---

Code First (Most Popular)

In Code First:
We create C# classes first, and EF creates database tables automatically.

---

Advantages of Entity Framework

• Less code
• Faster development
• Strongly typed queries
• Easy maintenance
• Good for large projects

---

Summary

✔ Entity Framework is an ORM
✔ Converts C# code into SQL
✔ Simplifies database operations
✔ Supports CRUD operations
✔ Most used in ASP.NET applications

---