title: Linq. Select from multiple tables
body: <p>In project I have this tables: </p>
  
  <ol>
  <li>Product(id,catalogId, manufacturerId...)</li>
  <li>Catalog</li>
  <li>Manufacturer</li>
  </ol>
  
  <p>Also <code>Product</code> model <code>(id, name, catalogId, catalogTitle, manufacturerId, manufacturerName)</code>.</p>
  
  <p>How can write in Linq this SQL query below if I want get Product item?<br/></p>
  
  <pre><code>SELECT Product.Name, Product.CatalogId, Product.ManufacturerId, [Catalog].Name, Manufacturer.Name
  FROM Product, [Catalog], Manufacturer
  WHERE [Catalog].Id=Product.CatalogId AND Manufacturer.id=Product.ManufacturerId AND Product.Active=1
  </code></pre>