static Lpp.Dns.DTO.QueryComposer.QueryComposerResponseDTO RunRequest(string requestJsonFilepath, string connectionString, Settings.SQLProvider sqlProvider = Settings.SQLProvider.SQLServer, string schema = null) { var request = LoadRequest(requestJsonFilepath); using (var adapter = Helper.CreatePCORIModelAdapterAdapter(connectionString, sqlProvider, schema)) { return(adapter.Execute(request, false)); } }
static Lpp.Dns.DTO.QueryComposer.QueryComposerResponseDTO RunRequestForSingleQueryResult(string requestJsonFilepath, string connectionString, Settings.SQLProvider sqlProvider = Settings.SQLProvider.SQLServer, string schema = null) { var request = LoadRequest(requestJsonFilepath); using (var adapter = Helper.CreatePCORIModelAdapterAdapter(connectionString, sqlProvider, schema)) { List <DTO.QueryComposer.QueryComposerResponseQueryResultDTO> queryResults = new List <DTO.QueryComposer.QueryComposerResponseQueryResultDTO>(); foreach (var query in request.Queries) { foreach (var result in adapter.Execute(query, false)) { queryResults.Add(result); } } var response = new DTO.QueryComposer.QueryComposerResponseDTO { Header = new DTO.QueryComposer.QueryComposerResponseHeaderDTO { DocumentID = Guid.NewGuid(), RequestID = Guid.NewGuid() }, Queries = queryResults }; response.RefreshQueryDates(); response.RefreshErrors(); return(response); } }