How to display related data in Entity Framework?

Question

C++ / C#

Something I'm already confused about the Entity Framework. I'm learning EF, I made a database using Model-first, a piece of the database on the screen .
How to display fields in datagridveiw, for example, title, price, and category name?
If used ProductGrid.DataSource = db.ProductSet.ToList();then it outputs System.Data.Entity.DynamicProxies.Category.

Answer 1

I would do like this:
1) I would declare a view class

class ProductDto
{
    [System.ComponentModel.DisplayName("ID")]
    [System.ComponentModel.Browsable(false)]
    public int ProductId { get; set; }
    
    [System.ComponentModel.DisplayName("Наименование")]
    public string ProductName { get; set; }
    
    [System.ComponentModel.DisplayName("Цена")]
    public float ProductPrice { get; set; }
    
    [System.ComponentModel.DisplayName("Категория")]
    public string Category { get; set; }

    [System.ComponentModel.DisplayName("Категория (ID)")]
    [System.ComponentModel.Browsable(false)]
    public int CategoryId { get; set; }    
}

I would get entries:

var dtos = (db.ProductSet.Include(x=>x.Category)
.Select(x => new ProductDto { 
   ProductId = x.ProductId, 
   ProductName = x.ProductName,
   ProductPrice = x.ProductPrice,
   Category = x.Category.CategoryName,
   CategoryId = x.Category.CategoryId
})).ToArray();

Well, it would already be tied to DataSoure, through the BindingSource class