public void ShouldReadDataFromCommitedTransaction()
{
// Given
var createTableQuery = new QueryObject("create table ##TransactionsTest ([ID] int, [Value] varchar(32));");
var insertQuery = new QueryObject("insert into ##TransactionsTest ([ID], [Value]) values (1, '123');");
var countQuery = new QueryObject("select count(*) from ##TransactionsTest;");
var dropTableQuery = new QueryObject("drop table ##TransactionsTest;");
using (var connection = ConnectionsFactory.Create())
try
{
// When
connection.Execute(createTableQuery);
using (var session = _sessionsFactory.Create())
{
session.Execute(insertQuery);
session.Commit();
}
// Then
int actualRecordsCount;
using (var session = _sessionsFactory.Create())
actualRecordsCount = session.Query <int>(countQuery).Single();
Assert.Equal(1, actualRecordsCount);
}
finally
{
connection.Execute(dropTableQuery);
}
}
public void ShouldGetExceptionOnAlreadyDisposedSession()
{
// Given
var session = _sessionsFactory.Create();
// When
session.Dispose();
// Then
Assert.Throws<ObjectDisposedException>(() => session.Commit());
}