public void SingleSqlQueryExecutesAndReturnsResult()
{
var mockSqlDialect = new Mock <ISqlDialect>();
var mockReader = new Mock <IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue <bool>(new[] { true, false }).Dequeue);
mockReader.As <IDisposable>().Setup(x => x.Dispose());
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
var mockConnection = new Mock <IDbConnection>();
mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object);
var mockDbDriver = new Mock <IDbDriver>();
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single <Customer>(new SqlQuery(""));
Assert.NotNull(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
}
public WhenExecutingTwoQueriesAndTheSqlDialectUsedSupportsBatching()
{
var mockSqlDialect = new Mock <ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull <IObjectInfo>(), It.IsNotNull <object>())).Returns(new SqlQuery(""));
this.mockDbDriver.Setup(x => x.Combine(It.IsNotNull <SqlQuery>(), It.IsNotNull <SqlQuery>())).Returns(new SqlQuery(""));
var mockReader = new Mock <IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue <bool>(new[] { true, false }).Dequeue);
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
var mockConnection = new Mock <IDbConnection>();
mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object);
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
mockDbDriver.Setup(x => x.SupportsBatchedQueries).Returns(true);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var includeCustomer = session.Include.Single <Customer>(2);
var customer = session.Single <Customer>(1);
}
public void SingleSqlQueryThrowsObjectDisposedExceptionIfDisposed()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock <ISqlDialect>().Object,
new Mock <IDbDriver>().Object);
using (session)
{
}
Assert.Throws <ObjectDisposedException>(
() => session.Single <Customer>(new SqlQuery("")));
}
public void SingleSqlQueryThrowsArgumentNullExceptionForNullSqlQuery()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock <ISqlDialect>().Object,
new Mock <IDbDriver>().Object);
SqlQuery sqlQuery = null;
var exception = Assert.Throws <ArgumentNullException>(
() => session.Single <Customer>(sqlQuery));
Assert.Equal("sqlQuery", exception.ParamName);
}
public void SingleIdentifierThrowsArgumentNullExceptionForNullIdentifier()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock <ISqlDialect>().Object,
new Mock <IDbDriver>().Object);
object identifier = null;
var exception = Assert.Throws <ArgumentNullException>(
() => session.Single <Customer>(identifier));
Assert.Equal("identifier", exception.ParamName);
}
public void SingleIdentifierExecutesAndReturnsNull()
{
object identifier = 100;
var mockReader = new Mock <IDataReader>();
mockReader.Setup(x => x.Read()).Returns(false);
mockReader.As <IDisposable>().Setup(x => x.Dispose());
var mockCommand = new Mock <IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
mockCommand.As <IDisposable>().Setup(x => x.Dispose());
var mockConnection = new Mock <IDbConnection>();
var mockSqlDialect = new Mock <ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull <IObjectInfo>(), identifier)).Returns(new SqlQuery(""));
var mockDbDriver = new Mock <IDbDriver>();
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
mockDbDriver.Setup(x => x.BuildCommand(It.IsNotNull <SqlQuery>())).Returns(mockCommand.Object);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single <Customer>(identifier);
Assert.Null(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
mockSqlDialect.VerifyAll();
}
public void SingleSqlQueryThrowsObjectDisposedExceptionIfDisposed()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock<ISqlDialect>().Object,
new Mock<IDbDriver>().Object);
using (session)
{
}
Assert.Throws<ObjectDisposedException>(
() => session.Single<Customer>(new SqlQuery("")));
}
public WhenExecutingTwoQueriesAndTheSqlDialectUsedSupportsBatching()
{
var mockSqlDialect = new Mock<ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull<IObjectInfo>(), It.IsNotNull<object>())).Returns(new SqlQuery(""));
this.mockDbDriver.Setup(x => x.Combine(It.IsNotNull<SqlQuery>(), It.IsNotNull<SqlQuery>())).Returns(new SqlQuery(""));
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue);
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
var mockConnection = new Mock<IDbConnection>();
mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object);
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
mockDbDriver.Setup(x => x.SupportsBatchedQueries).Returns(true);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var includeCustomer = session.Include.Single<Customer>(2);
var customer = session.Single<Customer>(1);
}
public void SingleSqlQueryExecutesAndReturnsResult()
{
var mockSqlDialect = new Mock<ISqlDialect>();
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue);
mockReader.As<IDisposable>().Setup(x => x.Dispose());
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
var mockConnection = new Mock<IDbConnection>();
mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object);
var mockDbDriver = new Mock<IDbDriver>();
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single<Customer>(new SqlQuery(""));
Assert.NotNull(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
}
public void SingleSqlQueryThrowsArgumentNullExceptionForNullSqlQuery()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock<ISqlDialect>().Object,
new Mock<IDbDriver>().Object);
SqlQuery sqlQuery = null;
var exception = Assert.Throws<ArgumentNullException>(
() => session.Single<Customer>(sqlQuery));
Assert.Equal("sqlQuery", exception.ParamName);
}
public void SingleIdentifierThrowsArgumentNullExceptionForNullIdentifier()
{
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
new Mock<ISqlDialect>().Object,
new Mock<IDbDriver>().Object);
object identifier = null;
var exception = Assert.Throws<ArgumentNullException>(
() => session.Single<Customer>(identifier));
Assert.Equal("identifier", exception.ParamName);
}
public void SingleIdentifierExecutesAndReturnsNull()
{
object identifier = 100;
var mockSqlDialect = new Mock<ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull<IObjectInfo>(), identifier)).Returns(new SqlQuery(""));
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(false);
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(mockReader.Object);
var mockConnection = new Mock<IDbConnection>();
mockConnection.Setup(x => x.CreateCommand()).Returns(mockCommand.Object);
var mockDbDriver = new Mock<IDbDriver>();
mockDbDriver.Setup(x => x.CreateConnection()).Returns(mockConnection.Object);
var session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single<Customer>(identifier);
Assert.Null(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
mockSqlDialect.VerifyAll();
}
public WhenExecutingMultipleQueriesAndTheSqlDialectUsedDoesNotSupportBatching()
{
var mockSqlDialect = new Mock<ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull<IObjectInfo>(), It.IsNotNull<object>())).Returns(new SqlQuery(""));
mockDbDriver.Setup(x => x.GetConnection(ConnectionScope.PerTransaction)).Returns(new Mock<IDbConnection>().Object);
mockDbDriver.Setup(x => x.SupportsBatchedQueries).Returns(false);
mockDbDriver.Setup(x => x.BuildCommand(It.IsNotNull<SqlQuery>())).Returns(() =>
{
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(() =>
{
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue);
return mockReader.Object;
});
return mockCommand.Object;
});
IReadOnlySession session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var includeCustomer = session.Include.Single<Customer>(2);
var customer = session.Single<Customer>(1);
}
public void SingleSqlQueryExecutesAndReturnsNull()
{
var sqlQuery = new SqlQuery("");
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(false);
var reader = mockReader.Object;
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(reader);
mockCommand.As<IDisposable>().Setup(x => x.Dispose());
var mockConnection = new Mock<IDbConnection>();
var mockSqlDialect = new Mock<ISqlDialect>();
var mockDbDriver = new Mock<IDbDriver>();
mockDbDriver.Setup(x => x.GetConnection(ConnectionScope.PerTransaction)).Returns(mockConnection.Object);
mockDbDriver.Setup(x => x.BuildCommand(sqlQuery)).Returns(mockCommand.Object);
IReadOnlySession session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single<Customer>(sqlQuery);
Assert.Null(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
}
public void SingleIdentifierExecutesAndReturnsResult()
{
object identifier = 100;
var mockReader = new Mock<IDataReader>();
mockReader.Setup(x => x.Read()).Returns(new Queue<bool>(new[] { true, false }).Dequeue);
var reader = mockReader.Object;
var mockCommand = new Mock<IDbCommand>();
mockCommand.Setup(x => x.ExecuteReader()).Returns(reader);
mockCommand.As<IDisposable>().Setup(x => x.Dispose());
var mockConnection = new Mock<IDbConnection>();
var mockSqlDialect = new Mock<ISqlDialect>();
mockSqlDialect.Setup(x => x.BuildSelectSqlQuery(It.IsNotNull<IObjectInfo>(), identifier)).Returns(new SqlQuery(""));
var mockDbDriver = new Mock<IDbDriver>();
mockDbDriver.Setup(x => x.GetConnection(ConnectionScope.PerTransaction)).Returns(mockConnection.Object);
mockDbDriver.Setup(x => x.BuildCommand(It.IsNotNull<SqlQuery>())).Returns(mockCommand.Object);
IReadOnlySession session = new ReadOnlySession(
ConnectionScope.PerTransaction,
mockSqlDialect.Object,
mockDbDriver.Object);
var customer = session.Single<Customer>(identifier);
Assert.NotNull(customer);
mockReader.VerifyAll();
mockCommand.VerifyAll();
mockConnection.VerifyAll();
mockSqlDialect.VerifyAll();
}