Querying Data with LINQ

🔍 Querying Data with LINQ

EF Core supports powerful querying using LINQ.

🧪 Basic Queries

var products = context.Products.ToList();

🔎 Filtering and Ordering

var cheapProducts = context.Products
    .Where(p => p.Price < 50)
    .OrderBy(p => p.Name)
    .ToList();

🔗 Including Related Data (Eager Loading)

var orders = context.Orders
    .Include(o => o.Customer)
    .ToList();

📝 Updating and Deleting Data

🔄 Updating Entities

var product = context.Products.Find(1);
product.Price = 99.99M;
context.SaveChanges();

❌ Deleting Entities

var product = context.Products.Find(1);
context.Products.Remove(product);
context.SaveChanges();