By default, EF Core loads all columns of an entity. Select() lets you project into a subset of properties, a DTO, or an anonymous type.