public static List <CompanyViewModel> GetListCompany() { List <CompanyViewModel> result = new List <CompanyViewModel>(); using (var context = new MarkomApplicationDBEntities()) { var res = context.spCompanyList(); List <CompanyViewModel> comList = res.Select(c => new CompanyViewModel { id = c.id, code = c.code, name = c.name, createDate = c.create_date, createBy = c.create_by }).ToList(); result = comList; } return(result); }