public void SqlTransConnection_OpenCloseTest()
{
using (var sut = new SqlTransConnection(TestCfg.Get().ConnectionString)) {
sut.Open();
Assert.Equal(System.Data.ConnectionState.Open, sut.Connection.State);
sut.Close();
Assert.Equal(System.Data.ConnectionState.Closed, sut.Connection.State);
}
}
public void SqlTransConnection_BeginTransactionTest()
{
using (var sut = new SqlTransConnection(TestCfg.Get().ConnectionString)) {
sut.Open();
Assert.Equal(System.Data.ConnectionState.Open, sut.Connection.State);
var t = sut.BeginTransaction(System.Data.IsolationLevel.Unspecified, "T");
sut.Commit(null);
Assert.NotNull(sut.Transaction);
sut.Commit(t);
sut.Close();
Assert.Equal(System.Data.ConnectionState.Closed, sut.Connection.State);
}
}
public void SqlTransConnection_ctor()
{
using (var sut = new SqlTransConnection((SqlConnection)null, null)) {
Assert.Null(sut.Connection);
Assert.Null(sut.Transaction);
}
using (var sut = new SqlTransConnection(new SqlConnection(), null)) {
Assert.NotNull(sut.Connection);
Assert.Null(sut.Transaction);
}
var csb = new SqlConnectionStringBuilder();
csb.DataSource = ".";
csb.InitialCatalog = "master";
using (var sut = new SqlTransConnection(csb.ConnectionString)) {
Assert.NotNull(sut.Connection);
Assert.Null(sut.Transaction);
}
}