public DbContext CreateSQLiteContext(SQLiteTestDatabase testDatabase)
        {
            var options
                = new DbContextOptions()
                  .UseModel(CreateModel())
                  .UseSQLite(testDatabase.Connection.ConnectionString);

            return(new DbContext(_serviceProvider, options));
        }
        public SQLiteTestDatabase CreateSQLiteTestDatabase()
        {
            var db = SQLiteTestDatabase.Scratch().Result;

            using (var context = CreateSQLiteContext(db))
            {
                context.Database.EnsureCreated();
            }

            return(db);
        }
        public NorthwindQueryFixture()
        {
            _serviceProvider
                = new ServiceCollection()
                  .AddEntityFramework()
                  .AddSQLite()
                  .UseLoggerFactory(_loggingFactory)
                  .ServiceCollection
                  .BuildServiceProvider();

            _testDatabase = SQLiteTestDatabase.Northwind().Result;

            _options = new DbContextOptions()
                       .UseModel(SetTableNames(CreateModel()))
                       .UseSQLite(_testDatabase.Connection.ConnectionString);
        }