title: How can I specify a "where" condition in my query?
body: <p>I have 2 tables, <code>Master</code> and a sub table</p>
  
  <p>Example </p>
  
  <p>Table <code>Menu</code></p>
  
  <pre><code>ID         MenuName
  ---         ------
  1            A
  2            B 
  3            C
  4            D
  </code></pre>
  
  <p>Table <code>MenuType</code>:</p>
  
  <pre><code>Id   MenuID   MenuType
  ---    ---    -------
  1      1       BreakFast
  2      1       Lunch
  3      1       Dinner 
  4      2       Lunch
  </code></pre>
  
  <p>I wanted to select </p>
  
  <pre><code>Select MenuName, ID 
  from Menu
  inner join MenuType on MenuType.MenuID = Menu.id
  </code></pre>
  
  <p>I wanted to fill this as <code>Menu</code> object to a checked list box.</p>
  
  <p>My code :</p>
  
  <pre><code>Dim ObMenu as List(of Menu)
  
  Dim Query=From un in dbcontest.menuCreations Select Un
  
  ObMenu =Query.ToList
  </code></pre>
  
  <p>How can I specify the <code>where</code> condition in this? In normal case we write it as </p>
  
  <pre><code>un.MenuType.MenuID = 1 
  </code></pre>
  
  <p>but as it's not one to one relation we can write it? So how can I write it?</p>