title: Linq syntax in VB.NET
body: <p>What I really want is to select these two tables in to an anon type like in Scott Gu's blog: <a href="http://weblogs.asp.net/scottgu/archive/2007/05/15/new-orcas-language-feature-anonymous-types.aspx?CommentPosted=true" rel="nofollow noreferrer">here</a> However, I would settle for this created type "ActiveLots" I am joining two tables together and want to be able to reference columns from each in my result set. </p>
  
  <p>I don't seem to be getting the syntax correctly. </p>
  
  <pre><code> Dim pi = From p In dc.Inventories Join i In dc.InventoryItems On p.InventoryItemID _
                       Equals i.InventoryItemID Where p.LotNumber &lt;&gt; "" _
                       Select New ActiveLots LotNumber = p.LotNumber, Quantity = p.Quantity, Item = i.Item, Uom = i.UnitofMeasure, Description = i.Description
  </code></pre>