public void Commit()
{
if (InternalStore.Count > 0)
{
DataTable dt;
int numberOfPages = (InternalStore.Count / CommitBatchSize) + (InternalStore.Count % CommitBatchSize == 0 ? 0 : 1);
for (int pageIndex = 0; pageIndex < numberOfPages; pageIndex++)
{
dt = InternalStore.Skip(pageIndex * CommitBatchSize).Take(CommitBatchSize).ToDataTable();
BulkInsert(dt);
}
}
}
/// <summary>
/// load list to the data base
/// </summary>
/// <returns>number of register rows</returns>
public long Commit()
{
long rowAffected = 0;
if (InternalStore.Count > 0)
{
DataTable dt;
int numberOfPages = (InternalStore.Count / CommitBatchSize) + (InternalStore.Count % CommitBatchSize == 0 ? 0 : 1);
for (int pageIndex = 0; pageIndex < numberOfPages; pageIndex++)
{
dt = InternalStore.Skip(pageIndex * CommitBatchSize).Take(CommitBatchSize).ToDataTable();
rowAffected += BulkInsert(dt);
}
}
return(rowAffected);
}
public void Commit()
{
if (InternalStore.Count <= 0)
{
return;
}
var numberOfPages = (InternalStore.Count / CommitBatchSize) +
(InternalStore.Count % CommitBatchSize == 0 ? 0 : 1);
for (var pageIndex = 0; pageIndex < numberOfPages; pageIndex++)
{
var dt = InternalStore.Skip(pageIndex * CommitBatchSize).Take(CommitBatchSize).ToDataTable();
BulkInsert(dt);
}
}
