Question

在Linq-to-SQL,我有一多问题。

我有一个表格,名称为user。

User has got 2 products > join product.UserID and Product can be have 2 equipment. Product to Equipments have many to many association

我想得到用户设备:

 var match =  from c in ctx.Products                              
    where c.UserID == USERID
    select c.Equipments;

该代码回归:<代码>I Queryable<System.Data.Objects.DataClasses.EntityCollection<Equipments>>打字标。

但我想到<代码>。 IQueryable<Equipments>打字标。我怎么说?

Answer 1

如同你想要的<代码>SelectMany一样。

var match =  from c in ctx.Products                              
    where c.UserID == USERID
    from e in c.Equipments
    select e;