protected void GivenANewTestSqlDbWithASingleEntity()
{
var dbServerName = LocalDbSetup.LocalDbServerName;
var dbName = "RepositoryCanDoCrudStory";
_conString =
$@"data source={dbServerName};initial catalog={
dbName
};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
// delete any existing databases
var dbSetup = new LocalDbSetup(Environment.CurrentDirectory, dbName);
dbSetup.CreateLocalDb(true);
// create db
using (var repositoryDb = new TestModel(_conString))
{
repositoryDb.MyEntities
.Add(new MyEntity {
Id = 1, Name = "Name", Date = _referencedate, Money = _referenceNumber
});
repositoryDb.SaveChanges();
}
// asser setup is complete
using (var repositoryDb = new TestModel(_conString))
{
var result = repositoryDb.MyEntities
.FirstOrDefault(m => m.Name == "Name");
Assert.NotNull(result);
}
}
protected void GivenASqlDatabaseWithData()
{
_dbName = GetType().Name;
var dbServerName = LocalDbSetup.LocalDbServerName;
if (string.IsNullOrWhiteSpace(_dbName))
{
throw new InvalidOperationException();
}
_conString =
$@"data source={dbServerName};initial catalog={
_dbName
};integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
// delete any existing databases
var dbSetup = new LocalDbSetup(Environment.CurrentDirectory, _dbName);
dbSetup.CreateLocalDb(true);
using (var db = new BulkDeletesModel(_conString))
{
db.Database.CreateIfNotExists();
for (int i = 0; i < 10; i++)
{
db.MyEntities.Add(new MyEntity()
{
Id = i, Name = "Name" + i
});
}
db.SaveChanges();
}
}
public void Dispose()
{
var dbSetup = new LocalDbSetup(Environment.CurrentDirectory, _dbName);
dbSetup.TryDetachDatabase();
}
