public void ConnectionStringIsValid()
{
// Arrange
var testdb = new SqlDatabaseTest();
// Act
var actual = testdb.ConnectionString;
// Assert
Assert.IsTrue(IsValidConnectionString(actual));
}
public void CtorDatabaseNameArg()
{
const string Expected = "CtorDatabaseNameArg";
using (var testdb = new SqlDatabaseTest(Expected))
{
// Arrange
// Act
var actual = testdb.DatabaseName;
var dataSource = testdb.DataSource;
// Assert
Assert.IsNotNull(actual);
Assert.AreEqual(Expected, actual);
Assert.AreEqual(Constants.LocalSqlExpress, dataSource);
}
}
public void CtorDatabaseNameDataSourceArg()
{
const string DatabaseName = "DatabaseName";
const string DataSource = "ServerName";
using (var testdb = new SqlDatabaseTest(DatabaseName, DataSource))
{
// Arrange
// Act
var actual = testdb.DatabaseName;
var dataSource = testdb.DataSource;
// Assert
Assert.IsNotNull(actual);
Assert.AreEqual(DatabaseName, actual);
Assert.AreEqual(DataSource, dataSource);
}
}
public void ViewExistsReturnsTrueWhenViewDoesNotExist()
{
using (var testdb = new SqlDatabaseTest())
{
// Arrange
testdb.Create();
// Act
var actual = testdb.ViewExists("NonExistent");
// Assert
Assert.IsFalse(actual);
}
}
public void SqlDatabaseTestShouldCreate()
{
using (var testdb = new SqlDatabaseTest())
{
// Arrange
// Act
testdb.Create();
// Assert
Assert.IsTrue(testdb.Exists(), "Create did not create test datbase");
}
}
public void ServerConnectionStringIsValid()
{
// Arrange
var testdb = new SqlDatabaseTest();
// Act
var actual = testdb.ServerConnectionString;
// Assert
Assert.IsTrue(IsValidConnectionString(actual));
var builder = new SqlConnectionStringBuilder(actual);
Assert.IsTrue(string.IsNullOrEmpty(builder.InitialCatalog));
}
public void DisposedAccessViewExistsThrows()
{
// Arrange
var testdb = new SqlDatabaseTest();
testdb.Dispose();
// Act
AssertHelper.Throws<ObjectDisposedException, bool>(() => testdb.ViewExists("Foo"));
}
public void DisposedAccessServerConnectionStringThrows()
{
// Arrange
var testdb = new SqlDatabaseTest();
testdb.Dispose();
// Act
AssertHelper.Throws<ObjectDisposedException>(() => { var actual = testdb.ServerConnectionString; });
}
public void DisposedAccessDropThrows()
{
// Arrange
var testdb = new SqlDatabaseTest();
testdb.Dispose();
// Act
AssertHelper.Throws<ObjectDisposedException>(testdb.Drop);
}
public void DisposedAccessCreateThrows()
{
// Arrange
var testdb = new SqlDatabaseTest();
testdb.Dispose();
// Act
AssertHelper.Throws<ObjectDisposedException>(() => testdb.Create());
}
public void CtorNoArgs()
{
using (var testdb = new SqlDatabaseTest())
{
// Arrange
// Act
var actual = testdb.DatabaseName;
var prefix = SqlDatabaseTest.DefaultPrefix;
var server = testdb.DataSource;
// Assert
Assert.IsNotNull(actual);
Assert.IsNotNull(prefix);
Assert.IsTrue(actual.StartsWith(prefix));
Assert.AreEqual(Constants.LocalSqlExpress, server);
}
}
