public static async Task <int> FillLoadDataRowChunkAsync(Action <Exception, DataTable, Object[]> onFillError, AdaSchemaMapping mapping, int startRecord, int maxRecords, CancellationToken cancellationToken)
{
AdaDataReaderContainer dataReader = mapping.DataReader;
while (0 < startRecord)
{
if (!await dataReader.ReadAsync(cancellationToken).ConfigureAwait(false))
{
// there are no more rows on first resultset
return(0);
}
--startRecord;
}
int rowsAddedToDataSet = 0;
if (0 < maxRecords)
{
while ((rowsAddedToDataSet < maxRecords) && await dataReader.ReadAsync(cancellationToken).ConfigureAwait(false))
{
try
{
await mapping.LoadDataRowWithClearAsync(cancellationToken).ConfigureAwait(false);
rowsAddedToDataSet++;
}
catch (Exception e) when(onFillError != null && ADP.IsCatchableExceptionType(e))
{
onFillError(e, mapping.DataTable, mapping.DataValues);
}
}
// skip remaining rows of the first resultset
}
else
{
rowsAddedToDataSet = await FillLoadDataRowAsync(onFillError, mapping, cancellationToken).ConfigureAwait(false);
}
return(rowsAddedToDataSet);
}
public static async Task <int> FillLoadDataRowAsync(Action <Exception, DataTable, Object[]> onFillError, AdaSchemaMapping mapping, CancellationToken cancellationToken)
{
int rowsAddedToDataSet = 0;
AdaDataReaderContainer dataReader = mapping.DataReader;
while (await dataReader.ReadAsync(cancellationToken).ConfigureAwait(false))
{ // read remaining rows of first and subsequent resultsets
try
{
// only try-catch if a FillErrorEventHandler is registered so that
// in the default case we get the full callstack from users
await mapping.LoadDataRowWithClearAsync(cancellationToken).ConfigureAwait(false);
rowsAddedToDataSet++;
}
catch (Exception e) when(onFillError != null && ADP.IsCatchableExceptionType(e))
{
onFillError(e, mapping.DataTable, mapping.DataValues);
}
}
return(rowsAddedToDataSet);
}