public static void Main(string[] args)
{
var files = ReadJsonFiles();
var dbContext = new FluentModelContext();
var repository = new OpenAccessRepository <SalesReport>(dbContext);
var unitOfWork = new OpenAccessUnitOfWork(dbContext);
ImportToMySqlDatabase(repository, unitOfWork, files);
}
private static void ImportToMySqlDatabase(OpenAccessRepository <SalesReport> salesRepository, OpenAccessUnitOfWork unitOfWork, IEnumerable <SalesReport> readFiles)
{
int count = 0;
foreach (var report in readFiles)
{
salesRepository.Add(report);
if (count % 100 == 0)
{
unitOfWork.Commit();
}
count++;
}
unitOfWork.Commit();
}
