public IList <EmployeeJoinedRow> FindByLastName(string lastName)
 {
     using (var adapter = new DataAccessAdapter())
     {
         var metaData = new LinqMetaData(adapter);
         var q        = metaData.GetEmployeeJoinedTypedList()
                        .Where(ec => ec.LastName == lastName);
         return(q.ToList());
     }
 }
 public IList <EmployeeJoinedRow> FindByEmployeeClassificationKey(int employeeClassificationKey)
 {
     using (var adapter = new DataAccessAdapter())
     {
         var metaData = new LinqMetaData(adapter);
         var q        = metaData.GetEmployeeJoinedTypedList()
                        .Where(ec => ec.EmployeeClassificationKey == employeeClassificationKey);
         return(q.ToList());
     }
 }