title: LINQ Union between two tables with the same fields and then returned in a collection
body: <p>I have given up trying to create a linq query to retrieve a sql server view which is a union between two tables. I will now try to create a linq union.</p>
  
  <p>I have two views, MemberDuesPaid and MemberDuesOwed. They have the same fields in both; (BatchNo, TranDate, DebitAmount, CreditAmount, ReceiptNo, CheckNo, SocSecNo). </p>
  
  <p>I also have a helper class in my application which is called MemberTransaction. It has all the same properties.</p>
  
  <p>How how do i do a union between the two tables where socSecNo = the ssn passed in? I want to union the two tables and return an IEnumerable collection of MemberTransaction. After the two tables are unioned together i want to have the collection that is returned ordered by trandate in descending order.</p>