public static List <Hospital> TopTenHospitalAppointment(DateTime fromDate, DateTime toDate) { List <Hospital> hospitals = null; using (LinqDBDataContext data = new LinqDBDataContext()) { hospitals = (from h in data.SP_LOAD_TOP_10_HOSPITAL_APPOINTMENT(fromDate, toDate) select new Hospital() { Hospital_ID = h.Hospital_ID, Hospital_Name = h.Hospital_Name, Rating_Count = h.Appointment_Count }).ToList <Hospital>(); } return(hospitals); }