static void Main(string[] args)
{
using (var context = new Core.DAL.EasyScheduleDatabaseEntities())
{
var products = context.Products;
context.Categories.Load();
foreach (var product in products)
{
product.FullName = product.Name + " [ " + product.Category.Name + " ]";
}
context.SaveChanges();
}
// Console.ReadKey();
}
//static void LoadDatabase()
//{
// using (var context = new SecretDatabaseEntities())
// {
// foodFinder.Products = new List<ProductLink>();
// foodFinder.Categories = context.Categories.Include("ProductLinks").ToList();
// foreach (var category in foodFinder.Categories)
// {
// foreach (var product in category.ProductLinks)
// {
// product.Category = category;
// }
// foodFinder.Products.AddRange(category.ProductLinks);
// }
// }
//}
//static void LoadCategories()
//{
// Console.Write("Fetching categories...");
// start = DateTime.Now;
// foodFinder.FetchFoodCategories();
// end = DateTime.Now;
// Console.WriteLine(" {0} ms\n", (end - start).TotalMilliseconds);
// Console.WriteLine("{0} categories fetched:", foodFinder.Categories.Count);
// foreach (var category in foodFinder.Categories)
// {
// Console.WriteLine("- {0}", category.Name);
// }
// Console.WriteLine("\n");
// using (var context = new SecretDatabaseEntities())
// {
// foreach (var category in foodFinder.Categories)
// {
// context.Categories.Add(new Category
// {
// CategoryTypeId = 1,
// Link = category.Link,
// Name = category.Name
// });
// }
// context.SaveChanges();
// }
//}
//static void LoadBrands()
//{
// start = DateTime.Now;
// var brands = foodFinder.FetchBrands(2).ToList();
// end = DateTime.Now;
// Console.WriteLine(" {0} ms\n", (end - start).TotalMilliseconds);
// Console.WriteLine("{0} brands fetched:", brands.Count);
// Console.WriteLine("\n");
// using (var context = new SecretDatabaseEntities())
// {
// foreach (var category in brands)
// {
// context.Categories.Add(category);
// }
// context.SaveChanges();
// Console.WriteLine("{0} rows were written to database", brands.Count);
// }
//}
//static void LoadRestaurants()
//{
// start = DateTime.Now;
// var brands = foodFinder.FetchBrands(3).ToList();
// end = DateTime.Now;
// Console.WriteLine(" {0} ms\n", (end - start).TotalMilliseconds);
// Console.WriteLine("{0} brands fetched:", brands.Count);
// Console.WriteLine("\n");
// using (var context = new SecretDatabaseEntities())
// {
// foreach (var category in brands)
// {
// context.Categories.Add(category);
// }
// context.SaveChanges();
// Console.WriteLine("{0} rows were written to database", brands.Count);
// }
//}
//static void LoadSupermarkets()
//{
// start = DateTime.Now;
// var brands = foodFinder.FetchBrands(4).ToList();
// end = DateTime.Now;
// Console.WriteLine(" {0} ms\n", (end - start).TotalMilliseconds);
// Console.WriteLine("{0} brands fetched:", brands.Count);
// Console.WriteLine("\n");
// using (var context = new SecretDatabaseEntities())
// {
// foreach (var category in brands)
// {
// context.Categories.Add(category);
// }
// context.SaveChanges();
// Console.WriteLine("{0} rows were written to database", brands.Count);
// }
//}
//static void LoadCategoryProducts()
//{
// foreach (var category in foodFinder.Categories)
// {
// Console.WriteLine("Go to {0} category", category.Name);
// Console.WriteLine("Fetching products list...");
// start = DateTime.Now;
// var list = foodFinder.FetchCategoryProducts(category);
// end = DateTime.Now;
// Console.WriteLine(" {0} ms\n", (end - start).TotalMilliseconds);
// Console.WriteLine("{0} products fetched", list.Count());
// using (var context = new SecretDatabaseEntities())
// {
// foreach (var product in category.ProductLinks.Where(p => p.Id < 1))
// {
// context.ProductLinks.Add(new ProductLink
// {
// Name = product.Name,
// CategoryId = product.Category.Id,
// Link = product.Link
// });
// }
// context.SaveChanges();
// Console.WriteLine("{0} rows were written to database");
// }
// }
//}
static void TransferCategories()
{
var secretContext = new Secret.SecretDatabaseEntities();
var scheduleContext = new Core.DAL.EasyScheduleDatabaseEntities();
foreach (var category in secretContext.Categories)
{
scheduleContext.Categories.Add(new Core.DAL.Category
{
Id = category.Id,
Name = category.Name,
CategoryTypeId = category.CategoryTypeId
});
scheduleContext.SaveChanges();
}
secretContext.Dispose();
scheduleContext.Dispose();
}