private static FooDbContext CreateFooDbContext(bool ensureDeleted) { var loggerFactory = CreateLoggerFactory(); var optionsBuilder = new DbContextOptionsBuilder <FooDbContext>(); optionsBuilder.UseSqlite("Data Source=FooDb.db"); //optionsBuilder.UseInMemoryDatabase("Data Source=FooDb.db"); optionsBuilder.UseLoggerFactory(loggerFactory); var dbContext = new FooDbContext(optionsBuilder.Options); if (ensureDeleted) { dbContext.Database.EnsureDeleted(); } dbContext.Database.EnsureCreated(); return(dbContext); }
public void TestMethod1() { using (AppDbContext appDb = new AppDbContext()) { appDb.Items.Add(new AppItems() { Name = "Item1", }); appDb.Items.Add(new AppItems() { Name = "Item2", }); appDb.Items.Add(new AppItems() { Name = "Item3", }); appDb.SaveChanges(); } using (FooDbContext fooDb = new FooDbContext()) { fooDb.FooItems.Add(new FooItems() { Name = "Foo1", }); fooDb.FooItems.Add(new FooItems() { Name = "Foo2", }); fooDb.FooItems.Add(new FooItems() { Name = "Foo3", }); fooDb.SaveChanges(); } // Query saved items using (AppDbContext appDb = new AppDbContext()) { var items = appDb.Items.ToList(); items.ForEach(c => log.Info("AppItem:" + c.Guid.ToString() + " name:" + c.Name)); } using (FooDbContext fooDb = new FooDbContext()) { var items = fooDb.FooItems.ToList(); items.ForEach(c => log.Info("FooItem: " + c.Guid.ToString() + " name:" + c.Name)); } }
public FileProcessorB(IFileReaderFactory fileReaderFactory, FooDbContext fooDb) { _fileReaderFactory = fileReaderFactory; _fooDb = fooDb; }
public FooController(FooDbContext context) { this.context = context; }
public PostSetTitle(FooDbContext db) { _db = db; }
public override void Up() { // Importing from CSV using(db = new FooDbContext()) ImportUtil.ImportFoos(db, "initial_foo_data.csv")); }
public AccountAppService(FooDbContext context) { _context = context; }
public Seed(FooDbContext dbContext) { _dbContext = dbContext; }