static void Main(string[] args)
{
//CreateSampleData();
for (int i = 0; i < 100; i++)
{
using (var nw = new northwindEntities())
{
var products = from p in nw.Products.Include("Categories")
select p;
var x = products.ToList();
using (var ngmd = new ProductsContext())
{
var rnd = new Random();
foreach (var product in products)
{
var imageNumber = rnd.Next(0, 6);
var ngArticle = new Article
{
Id = Guid.NewGuid(),
Name = product.ProductName,
Code = product.QuantityPerUnit,
Description =
"Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua.",
ImageUrl = String.Format("{0}.jpg", imageNumber)
};
Category cat;
var catId = product.Categories.CategoryID;
if (categoryStore.ContainsKey(catId))
{
cat = categoryStore[catId];
ngmd.Entry(cat).State = EntityState.Unchanged;
}
else
{
var guid = Guid.NewGuid();
cat = new Category
{
Name = product.Categories.CategoryName,
Description = product.Categories.Description,
Id = guid
};
categoryStore.Add(catId, cat);
ngmd.Categories.Add(cat);
ngmd.SaveChanges();
}
ngArticle.Category = cat;
ngmd.Articles.Add(ngArticle);
ngmd.SaveChanges();
}
}
}
}
}
