title: query this return list to show only records for a particular person. ASP.NET MVC
body: <p>I will like to query this return list to show only records for a particular person. Right now its show all records in the table. I am using ASP.NET MVC.
  This is my code</p>
  
  <pre><code>    public ActionResult Policies()
      {
  
  
          var eList = new List&lt;PolicyDTO&gt;();
          using (var ctx = new RetailPlusEntities())
          {
              eList = ctx.POLICies.Select(rec =&gt; new PolicyDTO()
  
              {
                  ID = rec.ID,
                  CUSTOMERID = rec.CUSTOMERID,
                  POLICYNO = rec.POLICYNO,
                  PLANID = rec.PLANID,
                  COMMENCEMENTDATE = rec.COMMENCEMENTDATE,
                  MATURITYDATE = rec.MATURITYDATE,
                  INITIALCONTRIBUTION = rec.INITIALCONTRIBUTION,
                  CARDNO = rec.CARDNO,
                  MARKERTERID = rec.MARKERTERID,
                  COLLECTORID = rec.COLLECTORID,
                  COVERID = rec.COVERID,
                  STATUS = rec.STATUS,
                  BRANCHID = rec.BRANCHID,
                  BranchName = rec.BRANCH.NAME,
                  EmployeName = rec.EMPLOYEE.FIRSTNAME,
                  StatusName = rec.STATUS1.NAME,
  
             }).ToList();
  
           //   }).Where(a =&gt; a.COLLECTORID.Equals(empID)).ToList();
  
          }
  
          return View(eList);
  
      }
  </code></pre>