private MainController()
 {
     Database.SetInitializer(new DropCreateDatabaseAlways<SupermarketContext>());
     //Database.SetInitializer(new MigrateDatabaseToLatestVersion<SupermarketContext, Configuration>());
     this.sQLServerContext = new SupermarketContext();
     this.mySqlContext = new SuperMarketEntitiesModel();
     this.excelConnection = new OleDbConnection();
     this.sqliteContext = new SuperMarketEntities();
 }
 public string ReadData()
 {
     StringBuilder sb = new StringBuilder();
     using (var context = new SuperMarketEntitiesModel())
     {
         sb.AppendLine("No Fetch optimization:");
         var query = context.Products.Where(p => p.ProductName.Contains("Coca"));
         sb.AppendLine("Product\tProductName");
         foreach (var product in query)
         {
             
             sb.AppendFormat("{0}\t{1}", product.ProductName, product.Vendor);
             sb.AppendLine();
         }
     }
     return sb.ToString();
 }
 public FromMySQLToSQLServer(SupermarketContext sqlServerContext,
                             SuperMarketEntitiesModel mySqlContext)
 {
     this.sqlServerContext = sqlServerContext;
     this.mySqlContext = mySqlContext;
 }