static void Main(string[] args)
{
Database.SetInitializer(new DropCreateDatabaseAlways<ModelDBTask3>());
using (ModelDBTask3 db = new ModelDBTask3())
{
Product p1 = new Product { Name = "Cola", Price = 10 } ;
Product p2 = new Product { Name = "Fanta", Price = 12 };
Product p3 = new Product { Name = "Sprite", Price = 11 };
db.Products.AddRange(new List<Product> { p1, p2, p3 });
db.SaveChanges();
Person person1 = new Person { Name = "Fred", Products = new List<Product> { p1 } };
Person person2 = new Person { Name = "Nick", Products = new List<Product> { p3 } };
Person person3 = new Person { Name = "Lena", Products = new List<Product> { p2 } };
db.Persons.AddRange(new List<Person> { person1, person2, person3 });
db.SaveChanges();
Console.WriteLine("connected complete...");
Console.ReadKey();
//---------------------------------------------------------
var ordBy = from pers in db.Persons
orderby pers.Name
select pers;
foreach (var item in ordBy)
{
Console.WriteLine(ordBy != null ? item.Name : "null");
}
Console.ReadKey();
//-----------------------------------------------------------------
var count = from pers in db.Persons
select new { Name = pers.Name, Count = pers.Products.Count() };
foreach (var item in count)
{
Console.WriteLine(item.Name + " has " + item.Count + "products");
}
Console.ReadKey();
}
}
static void Main(string[] args)
{
Database.SetInitializer(new DropCreateDatabaseAlways <ModelDBTask3>());
using (ModelDBTask3 db = new ModelDBTask3())
{
Product p1 = new Product {
Name = "Cola", Price = 10
};
Product p2 = new Product {
Name = "Fanta", Price = 12
};
Product p3 = new Product {
Name = "Sprite", Price = 11
};
db.Products.AddRange(new List <Product> {
p1, p2, p3
});
db.SaveChanges();
Person person1 = new Person {
Name = "Fred", Products = new List <Product> {
p1
}
};
Person person2 = new Person {
Name = "Nick", Products = new List <Product> {
p3
}
};
Person person3 = new Person {
Name = "Lena", Products = new List <Product> {
p2
}
};
db.Persons.AddRange(new List <Person> {
person1, person2, person3
});
db.SaveChanges();
Console.WriteLine("connected complete...");
Console.ReadKey();
//---------------------------------------------------------
var ordBy = from pers in db.Persons
orderby pers.Name
select pers;
foreach (var item in ordBy)
{
Console.WriteLine(ordBy != null ? item.Name : "null");
}
Console.ReadKey();
//-----------------------------------------------------------------
var count = from pers in db.Persons
select new { Name = pers.Name, Count = pers.Products.Count() };
foreach (var item in count)
{
Console.WriteLine(item.Name + " has " + item.Count + "products");
}
Console.ReadKey();
}
}
