public static List <ServiceEntity> LoadServicesByHospitalId(int id) { List <ServiceEntity> services = null; using (LinqDBDataContext data = new LinqDBDataContext()) { services = (from s in data.SP_LOAD_SERVICES_BY_HOSPITAL_ID(id) select new ServiceEntity() { Service_ID = s.Service_ID, Service_Name = s.Service_Name, Type_ID = s.Type_ID, Type_Name = s.Type_Name, Is_Active = s.Is_Active }).ToList <ServiceEntity>(); } return(services); }