Exemplo n.º 1
0
        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);
        }