public static void MigrateReports(ElectronicStoresSystemDbContext storeContext) { var mySqlContext = new ElectronicStoreMySQLFluentModel(); var reports = storeContext.Sales.OrderBy(s => s.Store.StoreName).ToList(); for (int i = 1, len = reports.Count; i < len; i++) { var newReport = new Report { ReportId = i, Price = reports[i].Price, ProductName = reports[i].Product.ProductName, Quantity = reports[i].Quantity, StoreName = reports[i].Store.StoreName, Sum = reports[i].Sum, }; using (var ctx = new ElectronicStoreMySQLFluentModel()) { ctx.Add(newReport); ctx.SaveChanges(); } } }
public static List<Report> LoadReports() { var ctx = new ElectronicStoreMySQLFluentModel(); using (ctx) { return ctx.Reports.ToList(); } }
public static void SaveReport(Report report) { var ctx = new ElectronicStoreMySQLFluentModel(); using (ctx) { ctx.Add(report); ctx.SaveChanges(); } }