public void BasicDatabaseTest()
{
// Arrange
var connectionStringBuilder =
new SqliteConnectionStringBuilder {
DataSource = ":memory:"
};
var connection = new SqliteConnection(connectionStringBuilder.ToString());
var options = new DbContextOptionsBuilder <ClimbingRoutesContext>()
.UseSqlite(connection)
.Options;
using (var context = new ClimbingRoutesContext(options))
{
context.Database.OpenConnection();
context.Database.EnsureCreated();
context.Users.Add(new Climber()
{
FirstName = "Matthew", LastName = "??", Email = "*****@*****.**"
});
context.Users.Add(new Climber()
{
FirstName = "Mark", LastName = "??", Email = "*****@*****.**"
});
context.Users.Add(new Climber()
{
FirstName = "Luke", LastName = "??", Email = "*****@*****.**"
});
context.Users.Add(new Climber()
{
FirstName = "John", LastName = "??", Email = "*****@*****.**"
});
context.SaveChanges();
}
int numUser;
// Three are added in the seed data. For a total of 7...
int expected = 7;
using (var context = new ClimbingRoutesContext(options))
{
// Act
numUser = context.Users.ToList().Count;
}
// Assert
Assert.Equal(numUser, expected);
}
public ClimbersController(ClimbingRoutesContext context, IMapper mapper)
{
_context = context ??
throw new ArgumentNullException(nameof(context));
context.Database.OpenConnection();
context.Database.EnsureCreated();
_mapper = mapper ??
throw new ArgumentNullException(nameof(mapper));
_set = context.Set <Climber>();
}
public static ClimbingRoutesContext GetNewContext()
{
var connectionStringBuilder =
new SqliteConnectionStringBuilder {
DataSource = ":memory:"
};
var connection = new SqliteConnection(connectionStringBuilder.ToString());
var options = new DbContextOptionsBuilder <ClimbingRoutesContext>()
.UseSqlite(connection)
.Options;
var context = new ClimbingRoutesContext(options);
context.Database.OpenConnection();
context.Database.EnsureCreated();
return(context);
}
