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;
}