public string GetAllEmployeeCompetencies(int EmployeeID) { var jsonSerialiser = new JavaScriptSerializer(); try { using (var db = new SSITrainingEntities()) { var snapshotEmployees = db.sp_CACompetency_GetAllEmployeeCompetencies(EmployeeID).ToList(); var json = jsonSerialiser.Serialize(snapshotEmployees); return(json); } } catch (Exception ex) { Console.WriteLine(ex.Message); return(""); } }