static void RunExample() { using (var context = new EFRecipesEntities()) { var hotel = new Hotel { Name = "Five Seasons Resort" }; var v1 = new Visitor { Name = "Alex Stevens" }; var v2 = new Visitor { Name = "Joan Hills" }; var r1 = new Reservation { Cost = 79.99M, Hotel = hotel, ReservationDate = DateTime.Parse("2/19/2010"), Visitor = v1 }; var r2 = new Reservation { Cost = 99.99M, Hotel = hotel, ReservationDate = DateTime.Parse("2/17/2010"), Visitor = v2 }; var r3 = new Reservation { Cost = 109.99M, Hotel = hotel, ReservationDate = DateTime.Parse("2/18/2010"), Visitor = v1 }; var r4 = new Reservation { Cost = 89.99M, Hotel = hotel, ReservationDate = DateTime.Parse("2/17/2010"), Visitor = v2 }; context.Hotels.AddObject(hotel); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Using eSql..."); var esql = @"Select value v from EFRecipesModel.VisitorSummary(DATETIME'2010-02-16 00:00', 7) as v"; var visitors = context.CreateQuery <DbDataRecord>(esql); foreach (var visitor in visitors) { Console.WriteLine("{0}, Total Reservations: {1}, Revenue: {2:C}", visitor["Name"], visitor["TotalReservations"], visitor["BusinessEarned"]); } } using (var context = new EFRecipesEntities()) { Console.WriteLine(); Console.WriteLine("Using LINQ..."); var visitors = from v in context.VisitorSummary(DateTime.Parse("2/16/2010"), 7) select v; foreach (var visitor in visitors) { Console.WriteLine("{0}, Total Reservations: {1}, Revenue: {2:C}", visitor["Name"], visitor["TotalReservations"], visitor["BusinessEarned"]); } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }
static void RunExample() { using (var context = new EFRecipesEntities()) { var post1 = new BlogPost { Title = "The Joy of LINQ", Description = "101 things you always wanted to know about LINQ" }; var post2 = new BlogPost { Title = "LINQ as Dinner Conversation", Description = "What wine goes with a Lambda expression?" }; var post3 = new BlogPost { Title = "LINQ and our Children", Description = "Why we need to teach LINQ in High School" }; var comment1 = new Comment { Comments = "Great post, I wish more people would talk about LINQ" }; var comment2 = new Comment { Comments = "You're right, we should teach LINQ in high school!" }; post1.Comments.Add(comment1); post3.Comments.Add(comment2); context.BlogPosts.AddObject(post1); context.BlogPosts.AddObject(post2); context.BlogPosts.AddObject(post3); context.SaveChanges(); } using (var context = new EFRecipesEntities()) { Console.WriteLine("Blog Posts with comments...(LINQ)"); var posts = from post in context.BlogPosts where post.Comments.Any() select post; foreach (var post in posts) { Console.WriteLine("Blog Post: {0}", post.Title); foreach (var comment in post.Comments) { Console.WriteLine("\t{0}", comment.Comments); } } } Console.WriteLine(); using (var context = new EFRecipesEntities()) { Console.WriteLine("Blog Posts with comments...(ESQL)"); var esql = "select value p from BlogPosts as p where exists(p.Comments)"; var posts = context.CreateQuery <BlogPost>(esql); foreach (var post in posts) { Console.WriteLine("Blog Post: {0}", post.Title); foreach (var comment in post.Comments) { Console.WriteLine("\t{0}", comment.Comments); } } } Console.WriteLine("Press <enter> to continue..."); Console.ReadLine(); }