public static void Main() { var sqlDB = new DatabaseContext(); var mongoDB = GetDatabase(DatabaseHost, DatabaseName); var makerIDsMongo = MigrateMakersTable(sqlDB, mongoDB); var modelIDsMongo = MigrateModelsTable(sqlDB, mongoDB); sqlDB.SaveChanges(); MigrateLaptopsTable(sqlDB, mongoDB, makerIDsMongo, modelIDsMongo); sqlDB.SaveChanges(); }
static void Main(string[] args) { using (var db = new DatabaseContext()) { int i = 1; ExcelReportReadingProvider.ReadZippedReports("../../../ExcelSampleData/GraphicsCardsReports.zip", "../../../ExcelSampleData/reports", x => { Console.WriteLine("Loading report row {4}: {0}GB {1}Ghz {2}$ {3}", x[0], x[1], x[2], x[3], i++); db.GraphicsCards.Add(new GraphicsCard() { MemorySize = decimal.Parse(x[0].ToString()), ClockSpeed = decimal.Parse(x[1].ToString()), Price = decimal.Parse(x[2].ToString()), Manufacturer = x[3].ToString() }); }); db.SaveChanges(); } }
public static void ProcessToMssql(IEnumerable<Product> products) { var db = new DatabaseContext(); foreach (var product in products) { foreach (var order in product.Orders) { var orderToAdd = new Models.EF.Order(order.Month, order.Count); var modelOfOrder = db.Models .Where(m => m.Name == product.ModelName) .FirstOrDefault(); orderToAdd.Model = modelOfOrder; db.Orders.Add(orderToAdd); } } db.SaveChanges(); }