C# Entity Framework Cheat Sheet

public class Blog{    public int Id { get; set; }    public string Title { get; set; } = string.Empty;    public List<Post> Posts { get; set; } = new();}public class AppDbContext : DbContext{    public DbSet<Blog> Blogs => Set<Blog>();    public DbSet<Post> Posts => Set<Post>();    protected override void OnConfiguring(DbContextOptionsBuilder options)        => options.UseSqlServer("Server=.;Database=BlogDb;Trusted_Connection=True;");}

using var db = new AppDbContext();// Createdb.Blogs.Add(new Blog { Title = "My Blog" });await db.SaveChangesAsync();// Readvar blog = await db.Blogs.FirstOrDefaultAsync(b => b.Title == "My Blog");var all = await db.Blogs.Include(b => b.Posts).ToListAsync();  // Eager load related data// Updateblog!.Title = "Updated Title";await db.SaveChangesAsync();// Deletedb.Blogs.Remove(blog);await db.SaveChangesAsync();

dotnet tool install --global dotnet-ef       # Install the EF Core CLI tooldotnet ef migrations add InitialCreate       # Generate a migration from model changesdotnet ef database update                    # Apply pending migrations to the databasedotnet ef migrations remove                  # Remove the last unapplied migration