CRUD Operations with EF Core

CRUD stands for Create, Read, Update, and Delete — the four basic operations used in persistent storage. In this lesson, you’ll implement these operations using Entity Framework Core.

Example Model: Product

We’ll use a simple Product class for our examples:

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
    public decimal Price { get; set; }
}

Create – Insert a New Record

using var context = new AppDbContext();

var product = new Product { Name = "Keyboard", Price = 29.99m };
context.Products.Add(product);
context.SaveChanges();

Read – Fetch Records

// Get all products
var products = context.Products.ToList();

// Get by ID
var product = context.Products.Find(1);

// Filtered query
var cheapItems = context.Products.Where(p => p.Price < 50).ToList();

Update – Modify an Existing Record

var product = context.Products.Find(1);
if (product != null)
{
    product.Price = 24.99m;
    context.SaveChanges();
}

Delete – Remove a Record

var product = context.Products.Find(1);
if (product != null)
{
    context.Products.Remove(product);
    context.SaveChanges();
}

Best Practices for CRUD

Use async methods (ToListAsync, FindAsync) in production
Handle exceptions with try-catch blocks
Use DTOs (Data Transfer Objects) to protect internal models

CRUD operations are the building blocks of any data-driven application. Now that you're comfortable with data access, we’ll explore how to apply schema changes using EF Core Migrations.

← Previous: DbContext and DbSet Next: EF Core Migrations →