Exemplos de LinqDBDataContext.SP_LOAD_TOP_10_HOSPITAL_APPOINTMENT em C# (CSharp)

Exemplo n.º 1

Arquivo: DataModel.cs Projeto: gvhung/hospital-finder

        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);
        }