Exemplos de LinqDBDataContext.SP_LOAD_FACILITIES_BY_HOSPITAL_ID em C# (CSharp)

Exemplo n.º 1

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

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