private IQuizRepository GetInMemoryQuizRepository()
{
var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
var factory = serviceProvider.GetService <ILoggerFactory>();
var _logger = factory.CreateLogger <QuizRepository>();
DbContextOptions <TriviaGameDbContext> options;
options = new DbContextOptionsBuilder <TriviaGameDbContext>().UseInMemoryDatabase(databaseName: "TriviaGameDbContext").Options;
TriviaGameDbContext _dbContext = new TriviaGameDbContext(options);
_dbContext.Database.EnsureDeleted();
DataAccess.Entities.User user = new DataAccess.Entities.User()
{
UserName = "******",
UserId = 3,
Email = "*****@*****.**",
};
DataAccess.Entities.Category cat1 = new DataAccess.Entities.Category()
{
Category1 = "Movies",
CategoryId = 1,
};
DataAccess.Entities.GameMode gm1 = new DataAccess.Entities.GameMode()
{
GameMode1 = "Normal",
GameModeId = 1,
};
_dbContext.User.Add(user);
_dbContext.Category.Add(cat1);
_dbContext.GameMode.Add(gm1);
_dbContext.Database.EnsureCreated();
return(new QuizRepository(_dbContext, _logger));
}
private IGameModeRepository GetInMemoryGameModeRepository()
{
var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
var factory = serviceProvider.GetService <ILoggerFactory>();
var _logger = factory.CreateLogger <GameModeRepository>();
DbContextOptions <TriviaGameDbContext> options;
options = new DbContextOptionsBuilder <TriviaGameDbContext>().UseInMemoryDatabase(databaseName: "TriviaGameDbContext").Options;
TriviaGameDbContext _dbContext = new TriviaGameDbContext(options);
_dbContext.Database.EnsureDeleted();
_dbContext.GameMode.AddRange(
new DataAccess.Entities.GameMode()
{
GameMode1 = "Normal",
GameModeId = 1,
},
new DataAccess.Entities.GameMode()
{
GameMode1 = "Hard",
GameModeId = 2,
}
);
//_dbContext.GameMode.AddRange(gm1, gm2);
//_dbContext.GameMode.Add(gm2);
_dbContext.Database.EnsureCreated();
return(new GameModeRepository(_dbContext, _logger));
}
private IQuestionRepository GetInMemoryQuestionRepository()
{
var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
var factory = serviceProvider.GetService <ILoggerFactory>();
var _logger = factory.CreateLogger <QuestionRepository>();
DbContextOptions <TriviaGameDbContext> options;
options = new DbContextOptionsBuilder <TriviaGameDbContext>().UseInMemoryDatabase(databaseName: "TriviaGameDbContext").Options;
TriviaGameDbContext _dbContext = new TriviaGameDbContext(options);
_dbContext.Database.EnsureDeleted();
//_dbContext.Question.Add(
// new DataAccess.Entities.Question()
// {
// QuestionId = 5,
// CategoryId = 1,
// Question1 = "Hello?",
// Value = 10,
// }
//);
//DataAccess.Entities.Category cat1 = new DataAccess.Entities.Category()
//{
// Category1 = "Movies",
// CategoryId = 1,
//};
//_dbContext.Category.Add(cat1);
_dbContext.Database.EnsureCreated();
return(new QuestionRepository(_dbContext, _logger));
}
private ICategoryRepository GetInMemoryCategoryRepository()
{
var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
var factory = serviceProvider.GetService <ILoggerFactory>();
var _logger = factory.CreateLogger <CategoryRepository>();
DbContextOptions <TriviaGameDbContext> options;
options = new DbContextOptionsBuilder <TriviaGameDbContext>().UseInMemoryDatabase(databaseName: "TriviaGameDbContext").Options;
TriviaGameDbContext _dbContext = new TriviaGameDbContext(options);
_dbContext.Database.EnsureDeleted();
DataAccess.Entities.Category cat1 = new DataAccess.Entities.Category()
{
Category1 = "Sports",
CategoryId = 1,
};
DataAccess.Entities.Category cat2 = new DataAccess.Entities.Category()
{
Category1 = "Movies",
CategoryId = 2,
};
_dbContext.Category.Add(cat1);
_dbContext.Category.Add(cat2);
_dbContext.Database.EnsureCreated();
return(new CategoryRepository(_dbContext, _logger));
}
private IUserRepository GetInMemoryUserRepository()
{
var serviceProvider = new ServiceCollection().AddLogging().BuildServiceProvider();
var factory = serviceProvider.GetService <ILoggerFactory>();
var _logger = factory.CreateLogger <UserRepository>();
DbContextOptions <TriviaGameDbContext> options;
//var builder = new DbContextOptionsBuilder<TriviaGameDbContext>();
//builder.UseInMemoryDatabase(builder, Action<InMemoryDbContextOptionsBuilder>);
//builder.UseInMemoryDatabase();
//options = builder.Options;
options = new DbContextOptionsBuilder <TriviaGameDbContext>().UseInMemoryDatabase(databaseName: "TriviaGameDbContext").Options;
TriviaGameDbContext _dbContext = new TriviaGameDbContext(options);
_dbContext.Database.EnsureDeleted();
_dbContext.Database.EnsureCreated();
return(new UserRepository(_dbContext, _logger));
}
public ChoiceRepository(TriviaGameDbContext dbContext, ILogger <ChoiceRepository> logger)
{
_dbContext = dbContext ?? throw new ArgumentException(nameof(dbContext));
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
}
public GameModeRepository(TriviaGameDbContext dbContext, ILogger <GameModeRepository> logger)
{
_dbContext = dbContext;
_logger = logger;
}
