static void Main(string[] args)
{
using (SQLiteEF.PeopleContext c = new SQLiteEF.PeopleContext())
{
List <SQLiteEF.Person> lst;
lst = c.People.ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.Take(5).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.OrderBy(i => i.LastName).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.OrderBy(i => i.Gender).ThenBy(i => i.LastName).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.Where(i => i.Gender == 1).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.Where(i => i.Gender == 1 && i.IsHealthy).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
lst = c.People.Where(i => i.Gender == 1 && i.IsHealthy).OrderBy(i => i.LastName).ToList();
lst.ForEach(i => Console.WriteLine(i));
Console.WriteLine();
var p = c.People.Where(i => i.PersonId == 1).FirstOrDefault();
p.Height = 150;
c.SaveChanges();
Console.WriteLine();
p = new SQLiteEF.Person();
p.FirstName = "a";
p.LastName = "b";
p.DateOfBirth = DateTime.Now;
p.Gender = 1;
p.Height = 180;
p.IsHealthy = true;
c.People.Add(p);
c.SaveChanges();
int id = p.PersonId;
Console.WriteLine($"Person oprettet med {id}");
p = c.People.Where(i => i.PersonId == id).FirstOrDefault();
c.People.Remove(p);
c.SaveChanges();
}
}
public IActionResult Index()
{
SQLiteEF.PeopleContext c = new SQLiteEF.PeopleContext();
var r = c.People.OrderBy(i => i.PersonId).ToList();
//var p = c.People.FirstOrDefault(i => i.PersonId == 1);
//p.LastName = "****";
//c.SaveChanges();
return(View(r));
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
using (SQLiteEF.PeopleContext c = new SQLiteEF.PeopleContext())
{
List <SQLiteEF.Person> lst;
lst = c.People.Take(5).ToList();
lst.ForEach(i => Console.WriteLine(i));
}
}
