public void CreateDatabaseCreatesNewDatabaseIfDatabaseAlreadyExists()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
_db = new LocalDbDatabase(_databaseName, filename);
// Make sure database exists.
_db.CreateDatabase();
AssertUsableDatabase(_db.ConnectionString);
// Now create it again.
_db.CreateDatabase();
AssertUsableDatabase(_db.ConnectionString);
}
public void CreateDatabaseCreatesAUseableDatabase()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
_db = new LocalDbDatabase(_databaseName, filename);
_db.CreateDatabase();
AssertUsableDatabase(_db.ConnectionString);
}
public void CreateDatabaseUsesCorrectFilename()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
_db = new LocalDbDatabase(_databaseName, filename);
Assert.False(File.Exists(filename));
_db.CreateDatabase();
Assert.True(File.Exists(filename));
}
public void CreateDatabaseWorksEvenIfFilesAlreadyExist()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
File.AppendAllText(filename, "foo");
_db = new LocalDbDatabase(_databaseName, filename);
_db.CreateDatabase();
AssertUsableDatabase(_db.ConnectionString);
}
public void DropDatabaseRemovesFilesFromFileSystem()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
_db = new LocalDbDatabase(_databaseName, filename);
// Make sure database exists.
_db.CreateDatabase();
Assert.True(File.Exists(filename));
_db.DropDatabase();
Assert.False(File.Exists(filename));
}
public void DropDatabaseRemovesDatabaseFromLocalDb()
{
var filename = Path.Combine(Path.GetTempPath(), _filename);
_db = new LocalDbDatabase(_databaseName, filename);
// Make sure database exists.
_db.CreateDatabase();
Assert.True(DatabaseExist(_db.MasterConnectionString, _databaseName));
_db.DropDatabase();
Assert.False(DatabaseExist(_db.MasterConnectionString, _databaseName));
}
public void DropDatabaseIgnoresErrorsWhenDataFileDoesNotExist()
{
var directory = Path.Combine(Path.GetTempPath(), Path.GetRandomFileName());
Directory.CreateDirectory(directory);
var filename = Path.Combine(directory, _filename);
_db = new LocalDbDatabase(_databaseName, filename);
_db.CreateDatabase();
// Let the filesystem let go of the file so it isn't in use.
Thread.Sleep(250);
Directory.Delete(directory, true);
_db = new LocalDbDatabase(_databaseName);
_db.CreateDatabase();
_db.DropDatabase();
}
