Entity Framework Core & Databases

Entity Framework Core is C#'s most widely used ORM — directly parallel to Java's Hibernate/Spring Data JPA — mapping classes to database tables and letting you query with LINQ instead of raw SQL.

class AppDbContext : DbContext {
    public DbSet<User> Users { get; set; }
}

using var db = new AppDbContext();
var user = db.Users.FirstOrDefault(u => u.Id == 1);

db.Users.Add(new User { Name = "Ada" });
db.SaveChanges();

EF Core generates the actual SQL from the LINQ query above, parameterizing values automatically — avoiding the SQL-injection risk of building queries by string concatenation.