title: How to convert sql inner join query into linq to sql query and convert into list
body: <p>I have below class:</p>
  
  <pre><code>public class customRequest
  {
      public string REQ_STATUS { get; set; }
      public DateTime REQ_RVE_DATnTIM { get; set; }
      public string EMP_FNAME { get; set; }
      public string EVE_CAT_NAME { get; set; }
      public string EVE_NAME { get; set; }
  }
  </code></pre>
  
  <p>and below SQL Inner Join Query which works perfect in SQL:</p>
  
  <pre><code>SELECT req.REQ_STATUS,req.REQ_RVE_DATnTIM, emp.EMP_FNAME, cat.EVE_CAT_NAME,eve.EVE_NAME from REQUESTS req inner join Employees emp on req.REQ_EMP_ID = emp.ID inner join EVENTCATEGORIES cat on req.REQ_EVE_CAT_ID = cat.ID inner join EVENTS eve on req.REQ_EVE_NAM_ID = eve.ID order by req.REQ_STATUS
  </code></pre>
  
  <p>What I want is to convert it into my linq to sql query. Below is my Linq to Sql query which I tried:</p>
  
  <pre><code>slist = from req in db.REQUESTS
                      join emp in db.Employees on req.REQ_EMP_ID equals emp.ID
                      join cat in db.EVENTCATEGORIES on req.REQ_EVE_CAT_ID equals cat.ID
                      join eve in db.EVENTS on req.REQ_EVE_NAM_ID equals eve.ID
                      select new { req.REQ_STATUS, req.REQ_RVE_DATnTIM, emp.EMP_FNAME, cat.EVE_CAT_NAME, eve.EVE_NAME };
          return slist.ToList();
  </code></pre>
  
  <p>But it shows me an error on last join:</p>
  
  <blockquote>
    <p>Error 1   Cannot implicitly convert type 'System.Linq.IQueryable' to 'System.Collections.Generic.List'. An explicit conversion exists (are you missing a cast?)    H:\64bit\Project Finalizing\Blue_Pumpkin\Blue_Pumpkin\Admin\Requests.aspx.cs    32  25  Blue_Pumpkin</p>
  </blockquote>