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