返回加入的 Linq 查询 C#

Question

我正在尝试将一个连接返回给我的类，但是它给我以下错误。

错误 1 无法隐式转换类型'System.Collections.Generic.List'到'System.Collections.Generic.List' C:\Projetos_ASP.NET\AdvanceTechniques\Models\Repository\ProductRepository.cs 40 30 AdvanceTechniques

下面是代码。

public List<Line> Get()
{
    return context.
        Lines.
        Join(
            context.Products,
            lines => lines.ID,
            products => products.LineID,
            ((products, lines)
                => new { lines, products}
        )).
        OrderByDescending(products => products.products.ID).ToList();
}

关注我的实体

public partial class Line
    {
        public Line()
        {
            this.Products = new List<Product>();
        }
        [Required]
        public long ID { get; set; }
        [Required]
        public string Name { get; set; }
        [Required]
        public string Slug { get; set; }
        [Required]
        public string DesktopImage { get; set; }
        [Required]
        public string MobileImage { get; set; }
        [Required]
        public string AltImage { get; set; }
        [Required]
        public int Position { get; set; }
        [Required]
        public bool IsActive { get; set; }

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

- LigDark

Answer 1

你不需要使用Join来返回每行产品，你只需要包含产品并像这样返回它们：

return context.Lines.Include("Products").ToList();

- Habib