title: Remove certain records from a set of records using LINQ
body: <p>Question - how to remove certain records from LINQ, like i have some records i wanted them to be removed from my LINQ. </p>
  
  <p>Scenario - i have table A with 10 records and table B with 2 records i want to remove records that are belong to B to be removed from A [using linq] 
  -below i have all the records in q and i want to remove the records that are there in p.</p>
  
  <pre><code>var p = from c in q
          join dr in dc.TableData on c.Id equals dr.CaseId
          select new View()
          {
              ActiveCaseId = c.ActiveCaseId,
              Id = c.Id                            
          };
  
  q = q.Except(p);
  </code></pre>