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