public IHttpActionResult GetAll_Coded() { try { //using (var dbContext = new RBSEntities()) //{ // var resources = dbContext.resource_list(); // return Ok(resources.ToList()); //}; //ResourceManager BL = new ResourceManager(); //List<Resource> result = BL.GetResources(); //return Ok(result); //Dispose to close connection //dbContext.Dispose(); //not useful because using the using BLResources mng = new BLResources(); IEnumerable <Resources> resource = mng.GetAll_Coded(); List <ResourcesVM> resources_list = new List <ResourcesVM>(); foreach (Resources es in resource) { ResourcesVM rs = new ResourcesVM() { id_resource = es.id_resource , name = es.name , surname = es.surname , email = es.email , username = es.username , admin = es.admin , status = es.status , insert_date = es.insert_date , update_date = es.update_date }; resources_list.Add(rs); } return(Ok(resources_list)); } catch (Exception ex) { return(InternalServerError(ex)); } }