private void button8_Click(object sender, RoutedEventArgs e) { ComputersFactoryContext context = new ComputersFactoryContext(); var rootNode = XMLHandler.ReadXMLFile("../../../../XMLFile/Manufacturers.xml"); MongoDBHanlder mongoDbHandler = new MongoDBHanlder("ScrewdriverDB"); XMLHandler.TransferXMLToSQLServer(context, rootNode); XMLHandler.TransferXMLToMongoDB(mongoDbHandler, rootNode); }
public static void Task5() { ComputersFactoryContext context = new ComputersFactoryContext(); var rootNode = XMLHandler.ReadXMLFile("../../../../XMLFile/Manufacturers.xml"); MongoDBHanlder mongoDbHandler = new MongoDBHanlder("ScrewdriverDB"); XMLHandler.TransferXMLToSQLServer(context, rootNode); XMLHandler.TransferXMLToMongoDB(mongoDbHandler, rootNode); }
public static void Task1() { //Button - Create Database Database.SetInitializer(new MigrateDatabaseToLatestVersion <ComputersFactoryContext, Configuration>()); var context = new ComputersFactoryContext(); context.Database.CreateIfNotExists(); //Button - Extract from Zip ZipHanlder.ExtractExcelFiles(@"..\..\..\..\Excel\Excel.zip"); //Button - Load Data from MongoDB to MSSQL var mongo = new MongoDBHanlder("ScrewdriverDB"); mongo.TransferToMSSQL().Wait(); //Button - Load data from Excel to MSSQL ExcelHandler.TransferAllData(); }
private async void LoadFromMongoDB_button(object sender, RoutedEventArgs e) { var mongo = new MongoDBHanlder("ScrewdriverDB"); await mongo.TransferToMSSQL(); }