public void SqlTrannectionShouldCloseItsConnectionWhenItIsDisposed() { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { testSubject.IsOpen.Should().BeFalse(); testSubject.ExecuteScalar<int>("select count(*) from sys.objects;").Result.Should().BeGreaterThan(10); testSubject.IsOpen.Should().BeTrue(); testSubject.Dispose(); testSubject.IsOpen.Should().BeFalse(); } }
public void SqlTrannectionShouldBeCommittable() { try { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { this.MakeJunkTable(testSubject); this.NumJunkTablesShouldBe(testSubject, 1); testSubject.Commit(); } using (var testSubject = new SqlServerTranection(LocalMasterDb)) { this.NumJunkTablesShouldBe(testSubject, 1); } } finally { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { this.RemoveJunkTable(testSubject); testSubject.Commit(); } } }
public void SqlTrannectionShouldExecuteNonQuery() { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { testSubject.ExecuteNonQuery(string.Format(CreateJunkTable, this._tableUid)) .Wait(); testSubject.ExecuteScalar<int>(string.Format(CountJunkTables, this._tableUid)) .Result.Should().Be(1); } }
private void RemoveJunkTable(SqlServerTranection testSubject) { testSubject.ExecuteNonQuery(string.Format(DropJunkTable, this._tableUid)) .Wait(); }
private void NumJunkTablesShouldBe(SqlServerTranection testSubject, int expected) { testSubject.ExecuteScalar<int>(string.Format(CountJunkTables, this._tableUid)) .Result.Should().Be(expected); }
public void SqlTrannectionShouldRollbackUnlessInstructedOtherwise() { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { this.MakeJunkTable(testSubject); this.NumJunkTablesShouldBe(testSubject, 1); } using (var testSubject = new SqlServerTranection(LocalMasterDb)) { this.NumJunkTablesShouldBe(testSubject, 0); } }
public void SqlTrannectionShouldExecuteSqlOnItsTarget() { using (var testSubject = new SqlServerTranection(LocalMasterDb)) { testSubject.ExecuteScalar<int>("select count(*) from sys.objects;").Result.Should().BeGreaterThan(10); } }