public static Dictionary <string, int> HospitalTypeCount() { Dictionary <string, int> hospitalTypes = new Dictionary <string, int>(); using (LinqDBDataContext data = new LinqDBDataContext()) { var temp = (from ht in data.SP_LOAD_HOSPITAL_TYPE_COUNT() select new { Type_Name = ht.Type_Name, HospitalType_Count = ht.HospitalType_Count }); foreach (var t in temp) { hospitalTypes.Add(t.Type_Name, (int)t.HospitalType_Count); } } return(hospitalTypes); }