Пример #1
0
        static void Main(string[] args)
        {
            Console.WriteLine("***** Fun with ADO.NET EF Core 2 *****\n");

            using (var context = new AutoLotContext())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
                foreach (inventory c in context.Cars)
                {
                    Console.WriteLine(c);
                }
            }

            Console.WriteLine("***** Using a Repository *****\n");
            using (var context = new AutoLotContext())
            {
                using var repo = new InventoryRepo(context);
                foreach (inventory c in repo.GetAll())
                {
                    Console.WriteLine(c);
                }
            }

            TestConcurrency();
            Console.ReadLine();
        }
Пример #2
0
        static void Main(string[] args)
        {
            Console.WriteLine("EF Core 2");
            using (var context = new AutoLotContext())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
                foreach (var car in context.Cars)
                {
                    Console.WriteLine(car);
                }
            }

            Console.WriteLine("Using Repository");
            using (var repo = new InventoryRepo())
            {
                foreach (var car in repo.GetAll())
                {
                    Console.WriteLine("Repo: " + car);
                }
            }
            Console.ReadLine();

            using (var context = new AutoLotContext())
            {
                var car = context.Cars.Include(x => x.Orders).ThenInclude(x => x.Customer).FirstOrDefault(x => x.Id == 4);
                Console.WriteLine($"The customer of {car} is:");
                Console.WriteLine(car.Orders.FirstOrDefault().Customer);
            }
        }
Пример #3
0
        static void Main(string[] args)
        {
            Console.WriteLine("FUN WITH EF CORE");

            using (var context = new AutoLotEntities())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);

                foreach (Inventory inv in context.Cars)
                {
                    Console.WriteLine(inv);
                }
            }

            Console.WriteLine("Fun with repos");

            using (var repo = new InventoryRepo())
            {
                foreach (var c in repo.GetAll())
                {
                    Console.WriteLine(c);
                }
            }

            Console.ReadLine();
        }
Пример #4
0
        public static void Main(string[] args)
        {
            var webHost = CreateHostBuilder(args).Build();

            using (var scope = webHost.Services.CreateScope())
            {
                var context = scope.ServiceProvider.GetRequiredService <AutoLotContext>();
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
            }
            webHost.Run();
        }
Пример #5
0
 private static void CreateDbIfNotExists(IHost host)
 {
     using (var scope = host.Services.CreateScope())
     {
         var services = scope.ServiceProvider;
         try
         {
             var context = services.GetRequiredService <JeopardyContext>();
             MyDataInitializer.ClearDatabaseData(context); // clear database tables
             MyDataInitializer.InitializeData(context);    // initialize the data
         }
         catch (Exception ex)
         {
             var logger = services.GetRequiredService <ILogger <Program> >();
             logger.LogError(ex, "An error occurred creating the DB.");
         }
     }
 }
Пример #6
0
 public static void Main(string[] args)
 {
     if (!RecreateDatabase)
     {
         CreateWebHostBuilder(args).Build().Run();
     }
     else
     {
         /* In case to recreate the database */
         var webHost = CreateWebHostBuilder(args).Build();
         using (var scope = webHost.Services.CreateScope()) //use Dependency Injection
         {
             var services = scope.ServiceProvider;
             var context  = services.GetRequiredService <AutoLotContext>();
             MyDataInitializer.RecreateDatabase(context);
             MyDataInitializer.InitializeData(context);
         }
         webHost.Run();
     }
 }
Пример #7
0
        static void Main(string[] args)
        {
            using (var context = new AutoLotContext())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
                foreach (Inventory c in context.Cars)
                {
                    Console.WriteLine(c);
                }

                using (var repo = new InventoryRepo(context))
                {
                    foreach (Inventory c in repo.GetAll())
                    {
                        Console.WriteLine(c);
                    }
                }
            }
            Console.ReadLine();
        }
Пример #8
0
        static void Main(string[] args)
        {
            Console.WriteLine("Function with ADO.NET EF Core 2 ****\n");

            using (var context = new AutoLotContext())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
                foreach (Inventory c in context.Cars)
                {
                    Console.WriteLine(c);
                }

                //Dependency Injection
                Console.WriteLine("Using a Repository\n");
                using (var repo = new InventoryRepo(context))
                {
                    foreach (Inventory c in repo.GetAll())
                    {
                        Console.WriteLine(c);
                    }
                }
                //Console.ReadLine();
            }

            //fallback
            Console.WriteLine("Using a Repository\n");
            using (var repo = new InventoryRepo())
            {
                foreach (Inventory c in repo.GetAll())
                {
                    Console.WriteLine(c);
                }
            }
            Console.ReadLine();
        }
Пример #9
0
        static void Main()
        {
            Console.WriteLine("FUN with ADO.NET EF Core 2\n");
            using (var context = new AutoLotContext())
            {
                MyDataInitializer.RecreateDatabase(context);
                MyDataInitializer.InitializeData(context);
                foreach (Inventory c in context.Cars)
                {
                    Console.WriteLine(c);
                }
            }

            Console.WriteLine("Using a Repository\n");
            using (var repo = new InventoryRepo())
            {
                foreach (Inventory c in repo.GetAll())
                {
                    Console.WriteLine(c);
                }
            }

            Console.ReadLine();
        }