public QueryConfig GetQueries() { QueryConfig config = new QueryConfig(); var metadataService = new MetadataService(); var metadataList = _dbContext.MetadataEntries.OrderBy(m => m.SortOrder).ToList(); foreach (var entry in metadataList) { var metadata = metadataService.GetMetadata(entry.Uuid); var wfsUrl = metadataService.GetWfsDistributionUrl(metadata.Related, entry.Uuid); if (!string.IsNullOrEmpty(wfsUrl)) { var SqUrl = metadataService.GetListStoredQueriesUrl(wfsUrl); var queries = new Wfs().GetStoredQueries(SqUrl); foreach (var query in queries) { config.AddQuery(new Query { Data = new Data { ObjectType = new ObjectType { Value = metadata.Uuid, Name = metadata.Title }, Name = query.ObjectType, Value = query.ObjectType , QueryUrl = query.QueryUrlTotal } , Name = query.Title, Value = query.Title.Replace(' ', '_'), QueryUrl = query.QueryUrl } ); } } } return(config); }