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