public static List <EmployeeViewModel> SearchStringEmployeeName(string prefix) { List <EmployeeViewModel> result = new List <EmployeeViewModel>(); try { using (MarkomApplicationDBEntities db = new MarkomApplicationDBEntities()) { var res = db.spEmployeeName(prefix); List <EmployeeViewModel> comList = res.Select(c => new EmployeeViewModel { id = c.id, fullName = c.first_name + ' ' + c.last_name }).ToList(); result = comList; } } catch (Exception ex) { Message = ex.Message; } return(result); }