private static void FromMySqlNeverAgain() { var dbcontext = new SupermarketContext(); var mySqlContx = new SupermarketModel(); using (mySqlContx) { var products = mySqlContx.Products.OrderBy(e => e.ID).ToList(); var vendors = mySqlContx.Vendors.ToList(); var mesuares = mySqlContx.Measures.ToList(); using (dbcontext) { foreach (var mesuare in mesuares) { var newMeasure = new Measure() { ID = mesuare.ID, Name = mesuare.Name }; dbcontext.Measures.Add(newMeasure); } foreach (var vendor in vendors) { var newVendor = new Vendor() { ID = vendor.ID, Name = vendor.Name }; dbcontext.Vendors.Add(newVendor); } foreach (var product in products) { var some = new Product { BasePrice = product.BasePrice, Measure_ID = product.Measure_ID, Name = product.Name, Vendor_ID = product.Vendor_ID, }; dbcontext.Products.Add(some); } dbcontext.SaveChanges(); } } }
private static void InitializeDataFromMySQL() { var db = new SupermarketContext(); SupermarketModel model = new SupermarketModel(); using (db) { foreach (var measure in model.Measures) { db.Measurments.Add(new Measure() { Id = measure.Id, MeasureName = measure.MeasureName }); } foreach (var vendor in model.Vendors) { db.Vendors.Add(new Vendor() { Id = vendor.Id, VendorName = vendor.VendorName }); } foreach (var product in model.Products) { db.Products.Add(new Product() { Id = product.Id, BasePrice = product.BasePrice, MeasureId=product.MeasureId, ProductName = product.ProductName, VendorId= product.VendorId }); } db.SaveChanges(); Console.WriteLine("1. Data from MySQL saved in SQL Server!"); } }