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()); } }