C# (CSharp) FactoryMySqlDbContext.UpdateDatabase Exemples

Exemple #1

        public static void Main()
        {
            var context = new FactoryDbContext();

            context.Database.CreateIfNotExists();

            var mongoData = GetDataFromMongoDb(Constants.DataName, Constants.CollectionName);
            var reports   = GetReportsDataFromExcel(Constants.ZipFilePath, Constants.UnzipedFilesPath);

            var productData = ProductMigrator.Instance.GetProductData(mongoData, context);

            PopulateSQLDbWithProducts(productData, context);

            var reportsData = ReportMigrator.Instance.GetReports(reports);

            PopulateSqlDbWithReports(reportsData, context);

            ImportXmlToMongoDb();
            ImportXMLToSqlServer();

            GenerateXMLReport(context, Constants.XmlReportsPath);
            GeneratePDFReport(context, Constants.PdfReportsPath);
            GenerateJSONReports(context, Constants.JsonReportsPath);

            var mySqlContext = new FactoryMySqlDbContext();

            mySqlContext.UpdateDatabase();
            PopulateMySQLDataBase(context, mySqlContext);

            //    var expensesPerModel = GetDataFromSQLite();
            //    var incomesPerModel = GetIncomePerModel(mySqlContext);
            //    CreateExcelYearlyFinancialResult(expensesPerModel, incomesPerModel);
        }