示例#1
0
        public static void Run_Audit()
        {
            using (var ctx = new DA.WWWingsContext())
            {
                ctx.Log();

                var flightSet = ctx.FlightSet.Where(x => x.Departure == "Berlin").ToList();
                foreach (var f in flightSet)
                {
                    f.FreeSeats--;
                    f.Memo = "Last change: " + DateTime.Now;
                }

                var audit = new Audit();
                ctx.SaveChanges(audit);

                // Changes stehen nun im audit-Objekt bereit
                foreach (var a in audit.Entries)
                {
                    Console.WriteLine("---------------" + a.Entity.ToString());
                    foreach (var p in a.Properties)
                    {
                        Console.WriteLine(p.PropertyName + ": " + p.OldValue + "->" + p.NewValue);
                    }
                }
            }
        }
示例#2
0
 public static void EFPlus_FutureQuery()
 {
     CUI.MainHeadline(nameof(EFPlus_FutureQuery));
     using (var ctx = new DA.WWWingsContext())
     {
         ctx.Log();
         CUI.Headline("Define three future queries ... nothing happens in the database");
         QueryFutureEnumerable <Pilot>  qAllePilots      = ctx.PilotSet.Future();
         QueryFutureEnumerable <Flight> qflightSetRome   = ctx.FlightSet.Where(x => x.Departure == "Rome").Future();
         QueryFutureEnumerable <Flight> qFlightSetBerlin = ctx.FlightSet.Where(x => x.Departure == "Berlin").Future();
         CUI.Headline("Access the pilots:");
         var allePilots = qAllePilots.ToList();
         Console.WriteLine(allePilots.Count + " Pilots are loaded!");
         CUI.Headline("Access the flights from Rome:");
         var flightSetRom = qflightSetRome.ToList();
         Console.WriteLine(flightSetRom.Count + " flights from Berlin are loaded!");
         CUI.Headline("Define another two future queries ... nothing happens in the database");
         QueryFutureEnumerable <Flight> qFugSetLondon   = ctx.FlightSet.Where(x => x.Departure == "London").Future();
         QueryFutureEnumerable <Flight> qflightSetParis = ctx.FlightSet.Where(x => x.Departure == "Paris").Future();
         CUI.Headline("Access the flights from Berlin:");
         var flightSetBerlin = qFlightSetBerlin.ToList();
         Console.WriteLine(flightSetBerlin.Count + " flights from Rome are loaded!");
         CUI.Headline("Access the flights from London:");
         var flightSetLondon = qFugSetLondon.ToList();
         Console.WriteLine(flightSetLondon.Count + " flights from London are loaded!");
         CUI.Headline("Access the flights from Paris:");
         var flightSetParis = qflightSetParis.ToList();
         Console.WriteLine(flightSetParis.Count + " flights from Paris are loaded!");
     }
 }
示例#3
0
        public static void EFPlus_FutureQuery_SingleObjectsAndValues()
        {
            CUI.MainHeadline(nameof(EFPlus_FutureQuery_SingleObjectsAndValues));
            using (var ctx = new DA.WWWingsContext())
            {
                ctx.Log();
                CUI.Headline("Define three future queries ... nothing happens in the database");
                QueryFutureValue <int>       qPilotCount            = ctx.PilotSet.DeferredCount().FutureValue();
                QueryFutureValue <DateTime?> qBirthdayOfOldestPilot = ctx.PilotSet.DeferredMin(x => x.Birthday).FutureValue();
                QueryFutureValue <Pilot>     qOldestPilot           = ctx.PilotSet.OrderBy(x => x.Birthday).DeferredFirstOrDefault().FutureValue();

                CUI.Headline("We need the values now!");
                Console.WriteLine("Number of pilots: " + qPilotCount.Value);
                Console.WriteLine("Birthday of oldest pilot: " + qBirthdayOfOldestPilot.Value.Value.ToShortDateString());
                Console.WriteLine("Name of of oldest pilot: " + qOldestPilot.Value.FullName);
            }
        }
示例#4
0
        public static void Run_Caching()
        {
            var ctx = new DA.WWWingsContext();

            ctx.Log();
            for (int i = 0; i < 10; i++)
            {
                //QueryCacheManager.
                // The query is cached using default QueryCacheManager options
                var flightSet1 = ctx.FlightSet.Where(x => x.Departure == "Rome").FromCache();
                Console.WriteLine(flightSet1.Count());
                // (EF7) The query is cached for 2 hours without any activity
                var options = new MemoryCacheEntryOptions()
                {
                    SlidingExpiration = TimeSpan.FromHours(2)
                };
                var flightSet2 = ctx.FlightSet.Where(x => x.Departure == "Rome").FromCache();
                Console.WriteLine(flightSet2.Count());
            }
        }
示例#5
0
        public static void Run_Filter()
        {
            // CREATE global filter
            QueryFilterManager.Filter <Flight>(x => x.Where(c => c.Departure == "Rome"));

            var ctx = new DA.WWWingsContext();

            ctx.Log();


            // TIP: Add this line in EntitiesContext constructor instead
            QueryFilterManager.InitilizeGlobalFilter(ctx);

            // SELECT * FROM Customer WHERE IsActive = true
            var customer = ctx.FlightSet.ToList();

            foreach (var f in customer)
            {
                Console.WriteLine(f);
            }
        }