🗄️ EF Core = Database ORM
SQL is tedious. Entity Framework Core is ORM. Query with C#, change tracking, migrations. Essential for .NET data access.
📝 Setting Up EF Core
# Install packages
dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.EntityFrameworkCore.Tools
# Create DbContext
public class AppDbContext : DbContext
{
public AppDbContext(DbContextOptions<AppDbContext> options)
: base(options)
{ }
public DbSet<User> Users { get; set; }
public DbSet<Order> Orders { get; set; }
}
# Models
public class User
{
public int Id { get; set; }
public string Name { get; set; }
public string Email { get; set; }
public DateTime CreatedAt { get; set; }
public List<Order> Orders { get; set; }
}
public class Order
{
public int Id { get; set; }
public int UserId { get; set; }
public decimal Total { get; set; }
public DateTime OrderDate { get; set; }
public User User { get; set; }
}
# Register in Program.cs
builder.Services.AddDbContext<AppDbContext>(options =>
options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));
🎯 Querying with EF Core
public class UserService
{
private readonly AppDbContext _context;
public UserService(AppDbContext context)
{
_context = context;
}
// Query examples
public async Task<User> GetUserByIdAsync(int id)
{
return await _context.Users
.Include(u => u.Orders)
.FirstOrDefaultAsync(u => u.Id == id);
}
public async Task<List<User>> GetActiveUsersAsync()
{
return await _context.Users
.Where(u => u.IsActive)
.OrderBy(u => u.Name)
.ToListAsync();
}
public async Task<User> CreateUserAsync(User user)
{
_context.Users.Add(user);
await _context.SaveChangesAsync();
return user;
}
public async Task<User> UpdateUserAsync(User user)
{
_context.Users.Update(user);
await _context.SaveChangesAsync();
return user;
}
public async Task DeleteUserAsync(int id)
{
var user = await _context.Users.FindAsync(id);
if (user != null)
{
_context.Users.Remove(user);
await _context.SaveChangesAsync();
}
}
// Complex query
public async Task<object> GetUserStatsAsync()
{
return await _context.Users
.GroupBy(u => u.CreatedAt.Date)
.Select(g => new {
Date = g.Key,
Count = g.Count()
})
.ToListAsync();
}
}
💡 EF Core Best Practices
- Use async methods
- Include related data (Include/ThenInclude)
- Use AsNoTracking for read-only queries
- Manage migrations
- Use repository pattern for separation
“EF Core simplifies data access. Query with C#, migrations, change tracking. Essential for .NET apps.”
