title: Linq to Entities many to many select query
body: <p>I am at a loss with the following query, which is peanuts in plain T-SQL.</p>
  
  <p>We have three physical tables: </p>
  
  <ul>
  <li>Band (PK=BandId)</li>
  <li>MusicStyle (PK=MuicStyleId)</li>
  <li>BandMusicStyle (PK=BandId+MusicStyleId, FK=BandId, MusicStyleId)</li>
  </ul>
  
  <p>Now what I'm trying to do is get a list of MusicStyles that are linked to a Band which contains a certain searchstring in it's name. The bandname should be in the result aswell.</p>
  
  <p>The T-SQL would be something like this:</p>
  
  <pre><code>SELECT b.Name, m.ID, m.Name, m.Description
  FROM Band b 
  INNER JOIN BandMusicStyle bm on b.BandId = bm.BandId
  INNER JOIN MusicStyle m on bm.MusicStyleId = m.MusicStyleId
  WHERE b.Name like '%@searchstring%'
  </code></pre>
  
  <p>How would I write this in Linq To Entities?</p>
  
  <p>PS: StackOverflow does not allow a search on the string 'many to many' for some bizar reason...</p>