public static void TransferDataFromOracleToMssql()
{
var oracleData = new SupermarketChainOracleData();
var mssqlData = new SupermarketChainMssqlData();
int productsAdded = 0;
int measuresAdded = 0;
int vendorsAdded = 0;
Console.WriteLine("Data transfer...");
var oracleVendors = oracleData.Vendors.All().ToList();
var oracleMeasures = oracleData.Measures.All().ToList();
var oracleProducts = oracleData.Products.All().ToList();
foreach (var oracleVendor in oracleVendors)
{
var checkIfVendorExists = mssqlData.Vendors.SearchFor(p => p.Name == oracleVendor.Name).FirstOrDefault();
if (checkIfVendorExists == null)
{
mssqlData.Vendors.Add(
new Vendor
{
Name = oracleVendor.Name
});
mssqlData.SaveChanges();
vendorsAdded++;
}
}
Console.WriteLine(vendorsAdded + " from " + oracleVendors.Count + " products added.");
Console.WriteLine(oracleVendors.Count - vendorsAdded + " vendors already exist in the database.");
foreach (var oracleMeasure in oracleMeasures)
{
var checkIfMeasureExists = mssqlData.Measures.SearchFor(p => p.Name == oracleMeasure.Name).FirstOrDefault();
if (checkIfMeasureExists == null)
{
mssqlData.Measures.Add(
new Measure
{
Name = oracleMeasure.Name
});
mssqlData.SaveChanges();
measuresAdded++;
}
}
Console.WriteLine(measuresAdded + " from " + oracleMeasures.Count + " products added.");
Console.WriteLine(oracleMeasures.Count - measuresAdded + " measures already exist in the database.");
foreach (var oracleProduct in oracleProducts)
{
var checkIfProductExists = mssqlData.Products.SearchFor(p => p.Name == oracleProduct.Name).FirstOrDefault();
if (checkIfProductExists == null)
{
mssqlData.Products.Add(
new Product
{
Name = oracleProduct.Name,
MeasureId = mssqlData.Measures.All().FirstOrDefault(m => m.Name == oracleProduct.Measure.Name).Id,
Price = oracleProduct.Price,
VendorId = mssqlData.Vendors.All().FirstOrDefault(m => m.Name == oracleProduct.Vendor.Name).Id
});
mssqlData.SaveChanges();
productsAdded++;
}
}
Console.WriteLine(productsAdded + " from " + oracleProducts.Count + " products added.");
Console.WriteLine(oracleProducts.Count - productsAdded + " products already exist in the database.");
}
public static void TransferDataFromOracleToMssql()
{
var oracleData = new SupermarketChainOracleData();
var mssqlData = new SupermarketChainMssqlData();
int productsAdded = 0;
int measuresAdded = 0;
int vendorsAdded = 0;
Console.WriteLine("Data transfer...");
var oracleVendors = oracleData.Vendors.All().ToList();
var oracleMeasures = oracleData.Measures.All().ToList();
var oracleProducts = oracleData.Products.All().ToList();
foreach (var oracleVendor in oracleVendors)
{
var checkIfVendorExists = mssqlData.Vendors.SearchFor(p => p.Name == oracleVendor.Name).FirstOrDefault();
if (checkIfVendorExists == null)
{
mssqlData.Vendors.Add(
new Vendor
{
Name = oracleVendor.Name
});
mssqlData.SaveChanges();
vendorsAdded++;
}
}
Console.WriteLine(vendorsAdded + " from " + oracleVendors.Count + " products added.");
Console.WriteLine(oracleVendors.Count - vendorsAdded + " vendors already exist in the database.");
foreach (var oracleMeasure in oracleMeasures)
{
var checkIfMeasureExists = mssqlData.Measures.SearchFor(p => p.Name == oracleMeasure.Name).FirstOrDefault();
if (checkIfMeasureExists == null)
{
mssqlData.Measures.Add(
new Measure
{
Name = oracleMeasure.Name
});
mssqlData.SaveChanges();
measuresAdded++;
}
}
Console.WriteLine(measuresAdded + " from " + oracleMeasures.Count + " products added.");
Console.WriteLine(oracleMeasures.Count - measuresAdded + " measures already exist in the database.");
foreach (var oracleProduct in oracleProducts)
{
var checkIfProductExists = mssqlData.Products.SearchFor(p => p.Name == oracleProduct.Name).FirstOrDefault();
if (checkIfProductExists == null)
{
mssqlData.Products.Add(
new Product
{
Name = oracleProduct.Name,
MeasureId = mssqlData.Measures.All().FirstOrDefault(m => m.Name == oracleProduct.Measure.Name).Id,
Price = oracleProduct.Price,
VendorId = mssqlData.Vendors.All().FirstOrDefault(m => m.Name == oracleProduct.Vendor.Name).Id
});
mssqlData.SaveChanges();
productsAdded++;
}
}
Console.WriteLine(productsAdded + " from " + oracleProducts.Count + " products added.");
Console.WriteLine(oracleProducts.Count - productsAdded + " products already exist in the database.");
}