public static string GetProductNameById(int id)
{
using (SupermarketMySqlEntities db = new SupermarketMySqlEntities())
{
//var product = db.Products.Single(p => p.ProductsId == id);
var product = db.Products.Where(p => p.ProductsId == id).First();
return product.ProductName;
}
}
public static void MigrateDataFromMySqlToMSSql()
{
using (SupermarketMySqlEntities mySqlDb = new SupermarketMySqlEntities())
{
using (SupermarketReportsEntities msSqlDb = new SupermarketReportsEntities())
{
var vendors = mySqlDb.Vendors;
foreach (var vendor in vendors)
{
SupermarketMSSql.Model.Vendor newVendor = new SupermarketMSSql.Model.Vendor
{
VendorName = vendor.VendorName
};
msSqlDb.Vendors.Add(newVendor);
}
msSqlDb.SaveChanges();
var measures = mySqlDb.Measures;
foreach (var measure in measures)
{
SupermarketMSSql.Model.Measure newMeasure = new SupermarketMSSql.Model.Measure
{
MeasureName = measure.MeasureName
};
msSqlDb.Measures.Add(newMeasure);
}
msSqlDb.SaveChanges();
var products = mySqlDb.Products;
foreach (var product in products)
{
var vendor = msSqlDb.Vendors.Where(v => v.VendorName == product.Vendor.VendorName).First();
var measure = msSqlDb.Measures.Where(m => m.MeasureName == product.Measure.MeasureName).First();
SupermarketMSSql.Model.Product newProduct = new SupermarketMSSql.Model.Product
{
ProductName = product.ProductName,
BasePrice = product.BasePrice,
Measures_MeasureId = measure.MeasureId,
Vendors_VendorId = vendor.VendorId
};
msSqlDb.Products.Add(newProduct);
}
msSqlDb.SaveChanges();
}
}
}