Example:var Query= from i in db.tbl select new{i.id,i.name....};
public List GetRequests(int reqStateID){return (from rs in db.ReqStateswhere rs.reqStateID== reqStateIDorderby rs.reqStateDate descendingselect rs).Distinct(new ReqStatesComparer()).ToList(); }