title: LINQ Query for fetching data from Multiple Tables
body: <p>I am working in <strong>Asp.Net 4.0 C#-- <em>MVC-3</em></strong>. I have one problem and don't know how to solve. I have 4 tables and want to fetch data from that tables with <strong>LINQ</strong>.</p>
  
  <p>TABLES</p>
  
  <p><strong>1) Project_Master</strong></p>
  
  <pre><code>    Field Names :   
  
      project_id (pk)
      project_name
      company_id (FK with company_master)
      company_category_id (FK with Company_Category_master)
      project_status_id (FK with Project_Status_Master)
  </code></pre>
  
  <p><strong>2)Company_Master</strong></p>
  
  <pre><code>   Field Names :
  
     company_id
     company_name
     company_category_id (FK with Company_Category_Master)
  </code></pre>
  
  <p><strong>3) Company_Category_Master</strong>     </p>
  
  <pre><code>   Field Names :
  
     Company_Category_Id
     Company_Category_Name
  </code></pre>
  
  <p><strong>4) Project_Status_Master</strong></p>
  
  <pre><code>   Field Name :
  
     Project_Status_Id
     Project_Status_Name
  </code></pre>
  
  <p>Below are the fields I need to fetch..(using LINQ Query)</p>
  
  <ol>
  <li><strong>Company_Name</strong> </li>
  <li><strong>Total completed project using status id(1)=complete</strong> (where staus 1 means completed)</li>
  <li><strong>Total Project</strong></li>
  <li><strong>Company_category_name</strong></li>
  </ol>
  
  <p>So, how can I fetch data with linq query??</p>
  
  <p>Thanks in advance...</p>