static void Cleanup() { using (var context = new EFRecipesEntities()) { context.ExecuteStoreCommand("delete from chapter3.registration"); } }
static void RunExample() { using (var context = new EFRecipesEntities()) { context.Registrations.AddObject(new Registration { StudentName = "Jill Rogers", RegistrationDate = DateTime.Parse("12/03/2009 9:30 pm") }); context.Registrations.AddObject(new Registration { StudentName = "Steven Combs", RegistrationDate = DateTime.Parse("12/03/2009 10:45 am") }); context.Registrations.AddObject(new Registration { StudentName = "Robin Rosen", RegistrationDate = DateTime.Parse("12/04/2009 11:18 am") }); context.Registrations.AddObject(new Registration { StudentName = "Allen Smith", RegistrationDate = DateTime.Parse("12/04/2009 3:31 pm") }); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { var groups = from r in context.Registrations group r by EntityFunctions.TruncateTime(r.RegistrationDate) into g select g; foreach (var element in groups) { Console.WriteLine("Registrations for {0}", ((DateTime)element.Key).ToShortDateString()); foreach (var registration in element) { Console.WriteLine("\t{0}", registration.StudentName); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }