public async Task Find_Element_On_DB()
{
var options = new DbContextOptionsBuilder <TemplatesDbContext>()
.UseInMemoryDatabase(databaseName: "Database_3")
.Options;
using (var context = new TemplatesDbContext(options))
{
var template = new Template
{
Id = TEMPLATE_ID_FOR_TESTING,
TemplateDescription = "Template Description",
TemplateName = "Template Name",
TemplateBody = "Template Body",
TemplateVariables = "variables"
};
var service = new TemplateRepository(context);
await service.InsertAsync(template);
var result = await service.GetAsync(TEMPLATE_ID_FOR_TESTING);
Assert.NotNull(result);
Assert.Equal(TEMPLATE_ID_FOR_TESTING, result.Id);
var resultsUsingQueryable = service.Query().Where(g => g.Id == TEMPLATE_ID_FOR_TESTING
).FirstOrDefault();
Assert.NotNull(resultsUsingQueryable);
Assert.Equal(TEMPLATE_ID_FOR_TESTING, resultsUsingQueryable.Id);
}
}
public async Task Delete_Template_To_DB()
{
var options = new DbContextOptionsBuilder <TemplatesDbContext>()
.UseInMemoryDatabase(databaseName: "Database_2")
.Options;
var template = new Template
{
Id = TEMPLATE_ID_FOR_TESTING,
TemplateDescription = "Template Description",
TemplateName = "Template Name",
TemplateBody = "Template Body",
TemplateVariables = "variables"
};
using (var context = new TemplatesDbContext(options))
{
var service = new TemplateRepository(context);
await service.InsertAsync(template);
var result = await service.GetAsync(TEMPLATE_ID_FOR_TESTING);
Assert.NotNull(result);
Assert.Equal(TEMPLATE_ID_FOR_TESTING, result.Id);
await service.UpdateAsync(template);
result = await service.GetAsync(TEMPLATE_ID_FOR_TESTING);
Assert.Equal(TEMPLATE_ID_FOR_TESTING, result.Id);
}
}
private static TemplatesDbContext ConfigigureDbContext()
{
var optionsBuilder = new DbContextOptionsBuilder <TemplatesDbContext>();
optionsBuilder.UseInMemoryDatabase("Templates");
var context = new TemplatesDbContext(optionsBuilder.Options);
context.Database.EnsureCreated();
return(context);
}
public TemplateRepository(TemplatesDbContext dbContext)
{
_dbContext = dbContext;
}
public TemplatesRepository(TemplatesDbContext context)
{
_context = context;
}
