public async Task <IEnumerable <dynamic> > ConvertAsync(MsSqlDbAttribute input, CancellationToken cancellationToken)
{
var context = _msSqlDbExtensionConfigProvider.CreateContext(input);
var sqlSpec = new MsSqlSpec()
{
Parameters = input.SqlQueryParameters,
Query = input.SqlQuery
};
var list = new List <object>();
#if NETCOREAPP3_1
var objects = context.MsSqlDbService.GetAsync(sqlSpec, cancellationToken);
await foreach (var o in objects.WithCancellation(cancellationToken))
{
list.Add(o);
}
#else
var objects = await context.MsSqlDbService.GetAsync(sqlSpec, cancellationToken);
list.AddRange(objects);
#endif
return(list.AsEnumerable());
}
public Task <T> ConvertAsync(MsSqlDbAttribute input, CancellationToken cancellationToken)
{
var context = _msSqlDbExtensionConfigProvider.CreateContext(input);
var sqlSpec = new MsSqlSpec()
{
Parameters = input.SqlQueryParameters,
Query = input.SqlQuery
};
return(context.MsSqlDbService.GetOne <T>(sqlSpec, cancellationToken));
}