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(); }
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); } }
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(); }
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(); }
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."); } } }
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(); } }
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(); }
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(); }
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(); }