private static void AddPerson()
{
Console.Write("Add new person(y/n)?");
if (Console.ReadKey().KeyChar.ToString().ToLower() != "y")
{
Console.Clear();
return;
}
Console.Clear();
var person = new Person();
Console.Write("Name: ");
person.Name = Console.ReadLine();
Console.Write("Age: ");
person.Age = int.Parse(Console.ReadLine());
Console.Write("Height: ");
person.Height = int.Parse(Console.ReadLine());
using (var db = new ESTest3())
{
db.Person.Add(person);
db.SaveChanges();
}
}
private static void DBTest()
{
using (var db = new ESTest3())
{
Console.WriteLine("----------------------------");
// Get first person in matching set.
var query = db.Person.Where(p => p.Age > 10 && p.Height < 170);
var person = query.FirstOrDefault<Person>();
Console.WriteLine($"First: {(person != null ? person.Name : string.Empty)}.");
Console.WriteLine("----------------------------");
// Tryes to get the first person in an empty set.
query = db.Person.Where(p => p.Age > 10 && p.Height < 20);
person = query.FirstOrDefault<Person>();
Console.WriteLine($"Second: {(person != null ? person.Name : string.Empty)}.");
Console.WriteLine("----------------------------");
// Gets all persons in matching set as a list (if nothing matches it returns an empty list).
var person2 = db.Person.Where(p => p.Age > 10 && p.Height < 200).ToList<Person>();
//Console.WriteLine(person2.GetType().ToString());
foreach (Person p in person2)
{
Console.WriteLine($"Third: {p.Name}.");
}
Console.WriteLine("----------------------------");
// Gets all persons inn te table.
foreach (Person p in db.Person)
{
Console.WriteLine($"Forth: {p.Name}.");
}
Console.WriteLine("----------------------------");
// Gets all persons in matching set as a list (if nothing matches it returns an empty DBQuery?).
var person3 = from p in db.Person
where p.Height == 189
select p;
//Console.WriteLine(person3.GetType().ToString());
foreach (Person p in person3)
{
Console.WriteLine($"Fifth: {p.Name}.");
}
Console.WriteLine("----------------------------");
}
}