private static void testLinqI(PetClubContext db)
{
Console.WriteLine("LINQ I");
var youngsters = db
.People
.Where(p => p.Age < 20)
.OrderByDescending(p => p.Age);
foreach (Person youngster in youngsters)
{
Console.WriteLine("Youngster: " + youngster);
}
}
private static void testEsql(PetClubContext db)
{
Console.WriteLine("ESQL");
string esql =
"SELECT VALUE p FROM People AS p WHERE p.Age < 20 ORDER BY p.Age";
var context = (db as IObjectContextAdapter).ObjectContext;
var youngsters = context.CreateQuery <Person>(esql);
foreach (Person youngster in youngsters)
{
Console.WriteLine("Youngster: " + youngster);
}
}
private static void testLinqII(PetClubContext db)
{
Console.WriteLine("LINQ II");
var youngsters =
from p in db.People
where p.Age < 20
orderby p.Age
select p;
foreach (Person youngster in youngsters)
{
Console.WriteLine("Youngster: " + youngster);
}
}
private static void addPeople(PetClubContext db)
{
db.People.Add(new Person {
FirstName = "Ib", LastName = "Svensen", Age = 87
});
db.People.Add(new Person {
FirstName = "Gurli", LastName = "Poulse", Age = 7
});
db.People.Add(new Person {
FirstName = "Maj", LastName = "Petersen", Age = 12
});
db.People.Add(new Person {
FirstName = "Mickael", LastName = "Peterson", Age = 14
});
db.SaveChanges();
}
static void Main(string[] args)
{
using (var db = new PetClubContext()) {
//setup(db);
//addPeople(db);
//testEsql(db);
//testLinqI(db);
//testLinqII(db);
//var pets = db.Pets.Select(p => new { PetName = p.Name, OwnerName = p.Owner.FirstName });
//foreach (var pet in pets)
// Console.WriteLine(">>>"+pet.PetName+" "+pet.OwnerName);
var pets = db.Pets.Include(p => p.Owner);
foreach (Pet pet in pets)
{
Console.WriteLine(">>> " + pet.Name + " " + pet.Owner.FirstName);
}
}
Console.ReadKey();
}
private static void setup(PetClubContext db)
{
Club rabbits = new Club {
Code = "RBT", Name = "Kaninklubben Kaj"
};
db.Clubs.Add(rabbits);
Console.WriteLine("Kaninmedlemmer: " + rabbits.Members);
Person kurt = new Person {
FirstName = "Kurt", LastName = "Hansen", Age = 34
};
Person sonja = new Person {
FirstName = "Sonja", LastName = "Hansen", Age = 28
};
rabbits.Members.Add(kurt);
rabbits.Members.Add(sonja);
rabbits.Chairman = sonja;
Cat felix = new Cat {
Name = "Felix", LiveCount = 5, Owner = kurt
};
Dog rufus = new Dog {
Name = "Rufus", BarkPitch = "C2", Owner = kurt
};
Pet ninus = new Pet {
Name = "Ninus"
};
sonja.Pets.Add(ninus);
db.Pets.Add(felix);
db.Pets.Add(rufus);
db.SaveChanges();
foreach (Pet pet in kurt.Pets)
{
Console.WriteLine(pet.Name);
}
}