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)); } }