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); } }