public static List <FacilityEntity> LoadFacillitiesByHospitalId(int id) { List <FacilityEntity> facilities = null; using (LinqDBDataContext data = new LinqDBDataContext()) { facilities = (from f in data.SP_LOAD_FACILITIES_BY_HOSPITAL_ID(id) select new FacilityEntity() { Facility_ID = f.Facility_ID, Facility_Name = f.Facility_Name, Type_ID = f.Type_ID, Type_Name = f.Type_Name, Is_Active = f.Is_Active }).ToList <FacilityEntity>(); } return(facilities); }