如何使用多对多连接表在C＃查询语法中执行SelectMany？

Question

我有下面的C＃声明通过EF产生正是我要找的，但很好奇，我怎么会写这与查询语法：

var dealers = this.Dealers 
    .SelectMany (d => d.Brands, (d, col) => new { Name = d.Name, Brand = col.Name, StatusId = d.StatusId }) 
    .Where (d => d.StatusId == 1); 

Answer 1

var dealers = from d in Dealers 
       from col in d.Brands 
       where d.StatusId == 1 
       select new { Name = d.Name, 
          Brand = col.Name, 
          StatusId = d.StatusId };