title: How do I perform a SelectMany in C# query syntax using a many-to-many joining table?
body: <p>I have the following c# statement that via EF generates exactly what I'm looking for but am curious as to how I'd write this with query syntax:</p>
  
  <pre><code>var dealers = this.Dealers
      .SelectMany (d =&gt; d.Brands, (d, col) =&gt; new { Name = d.Name, Brand = col.Name, StatusId = d.StatusId })
      .Where (d =&gt; d.StatusId == 1);
  </code></pre>