Example #1
0
        private static void AddObject()
        {
            BookEntities ctx     = new BookEntities();
            Film         NewFilm = new Film();

            NewFilm.Title       = "New film";
            NewFilm.Description = "New film";
            NewFilm.Length      = 300;
            FilmShowing NewFilmShowing = new FilmShowing();

            NewFilmShowing.Screen      = 5;
            NewFilmShowing.ShowingDate = System.DateTime.Now;
            NewFilm.FilmShowings.Add(NewFilmShowing);
            ctx.AddObject("Films", NewFilm);
            ctx.SaveChanges();


            //Another option
            //BookEntities ctx = new BookEntities();
            //Film NewFilm = Film.CreateFilm(0);
            //NewFilm.Title = "New film2";
            //NewFilm.Description = "New film";
            //NewFilm.Length = 300;
            //ctx.AddToFilms(NewFilm);
            //ctx.SaveChanges();
        }
Example #2
0
        static void Main(string[] args)
        {
            ModelDefinedFunction();

            Console.ReadKey();
            BookEntities ctx   = new BookEntities();
            var          query = from o in ctx.Orders
                                 select o;

            foreach (Order order in query)
            {
                Console.WriteLine("Order: " + order.OrderID.ToString() + " " + order.Firstname
                                  + " "
                                  + order.Lastname);
                order.OrderItems.Load();
                foreach (OrderItem orderItem in order.OrderItems)
                {
                    Console.WriteLine("Adult: " + orderItem.QtyAdult.ToString() + " Child:"
                                      + orderItem.QtyChild.ToString());
                }
                Console.WriteLine("");
            }
            Console.ReadKey();


            //ObjectQuery option
            //ObjectQuery<Order> query = ctx.Orders.OrderBy("it.OrderID");

            //string queryString = @"SELECT VALUE o FROM BookEntities.Orders AS o";
            //ObjectQuery<Order> query = new ObjectQuery<Order>(queryString, ctx, MergeOption.NoTracking);
        }
Example #3
0
        private static void Updating()
        {
            BookEntities ctx          = new BookEntities();
            Film         FilmToUpdate = ctx.Films.Where("it.FilmID = 3").First();

            FilmToUpdate.Title = "New updated title";
            ctx.SaveChanges();
        }
Example #4
0
        private static void Deleting()
        {
            BookEntities ctx = new BookEntities();

            ctx.Films.DeleteObject(ctx.Films.Where("it.FilmID = 5").First());
            foreach (FilmShowing fs in ctx.FilmShowings.Where("it.FilmID = 5"))
            {
                ctx.FilmShowings.DeleteObject(fs);
            }
        }
Example #5
0
 private static void ModelDefinedFunction()
 {
     BookEntities ctx   = new BookEntities();
     var          query = from f in ctx.Films
                          select new { FullName = MDF.LongFilmDescription(f) };
 }