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;
}
