static void Main() { Database.SetInitializer(new MigrateDatabaseToLatestVersion<SupermarketContext, Configuration>()); var db = new SupermarketContext(); string conStr = "Server=localhost; Port=3306; Database=supermarketdb; Uid=root; Pwd=6okolad; pooling=true"; SupermarketModel mySqlDB = new SupermarketModel(conStr); db.Database.Delete(); TransferData(mySqlDB, db); TransferDataConnTable(mySqlDB, db); db.Database.Connection.Close(); //Unpack data from zip file ZipDataReader.ExtractData(@"../../../Sample-Sales-Reports.zip", @"../../../Extracted Files"); ExcelDataReader.TransferDataFromExcelToDB(db, "../../../Extracted Files"); Directory.Delete(@"../../../Extracted Files", true); //Create Pdf File CreatePdf.AddDataToPdf(db); //Create XML File CreateXMLDocument.AddDataToXML(db); //Save Json files in the file system CreateJsonDocument.saveJsonFiles(@"../../../Product-Reports", db); CreateJsonDocument.saveReportsToMongoDB(db); }
// Copy data from auto-generates MySql classes to code first made classes for MS SQL Database public static void TransferData(SupermarketModel mySQL, SupermarketContext msSQL) { foreach (var measure in mySQL.Measures) { var newMeasure = new SupermarketDB.Models.Measure { MeasureID = measure.MeasureID, MeasureName = measure.MeasureName }; msSQL.Measures.Add(newMeasure); msSQL.SaveChanges(); } foreach (var vendor in mySQL.Vendors) { var newVendor = new SupermarketDB.Models.Vendor { VendorID = vendor.VendorID, VendorName = vendor.VendorName }; msSQL.Vendors.Add(newVendor); msSQL.SaveChanges(); } }
public static void TransferDataConnTable(SupermarketModel mySQL, SupermarketContext msSQL) { foreach (var product in mySQL.Products) { var newProduct = new SupermarketDB.Models.Product { ProductID = product.ProductID, VendorID = product.VendorID, MeasureID = product.MeasureID, ProductName = product.ProductName, BasePrice = product.BasePrice }; msSQL.Products.Add(newProduct); msSQL.SaveChanges(); } }