Entity Framework, Automapper oraz projekcja

Category.cs

public class Category
{
    public int Id { get; set; }

    public string Name { get; set; }

    public string Description { get; set; }

    public virtual ICollection<Product> Products { get; set; }
}

MapTest.cs

static void Main(string[] args)
{
    HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize();

    MapTest();
}

static void MapTest()
{
    var config = new MapperConfiguration(cfg => {
        cfg.CreateMap<Product, ProductViewModel>()
            .ForMember(dest => dest.Category, opt => opt.MapFrom(src => src.Category.Name));
    });

    var mapper = config.CreateMapper();

    using (var db = new DataContext())
    {
        var products = mapper.Map<List<ProductViewModel>>(db.Products.ToList());
    }
}

Product.cs

public class Product
{
    public int Id { get; set; }

    public string Name { get; set; }

    public int CategoryId { get; set; }

    public virtual Category Category { get; set; }

    public ProductType Type { get; set; }
}

public enum ProductType
{
    Virtual,
    Physical
}

ProductViewModel.cs

public class ProductViewModel
{
    public int Id { get; set; }

    public string Name { get; set; }

    public string Category { get; set; }

    public string Type { get; set; }
}

ProjectToTest.cs

static void Main(string[] args)
{
    HibernatingRhinos.Profiler.Appender.EntityFramework.EntityFrameworkProfiler.Initialize();

    ProjectToTest();
}

static void ProjectToTest()
{
    var config = new MapperConfiguration(cfg => {
        cfg.CreateMap<Product, ProductViewModel>()
            .ForMember(dest => dest.Category, opt => opt.MapFrom(src => src.Category.Name));
    });

    var mapper = config.CreateMapper();

    using (var db = new DataContext())
    {
        var products = mapper.ProjectTo<ProductViewModel>(db.Products).ToList();
    }
}

Select.cs

var products = db.Products.Select(p => new ProductViewModel()
{
    Id = p.Id,
    Name = p.Name,
    Category = p.Category.Name
}).ToList();