public void GetDbCommandText()
{
var dbConnection = new DbConnectionMock();
dynamic queries = new DbCommandRepository(dbConnection, "TestData");
string commandText = queries.Select; // Behavior inherited from FileRepository
TestDataUtility.AreEqual(commandText, ".sql", "select");
}
public void GetDbCommand()
{
var dbConnection = new DbConnectionMock();
dynamic queries = new DbCommandRepository(dbConnection, "TestData");
IDbCommand command = queries.Select();
TestDataUtility.AreEqual(command.CommandText, ".sql", "select");
Assert.IsInstanceOfType(command, typeof(DbCommandMock));
var commandMock = (DbCommandMock)command;
Assert.AreEqual(0, commandMock.ParameterMocks.Count);
}
public void GetDbCommandWithParameters()
{
var dbConnection = new DbConnectionMock();
dynamic queries = new DbCommandRepository(dbConnection, "TestData");
IDbCommand command = queries.Select("Param1", 123);
TestDataUtility.AreEqual(command.CommandText, ".sql", "select");
Assert.IsInstanceOfType(command, typeof(DbCommandMock));
var commandMock = (DbCommandMock)command;
Assert.AreEqual(2, commandMock.ParameterMocks.Count);
Assert.AreEqual("0", commandMock.ParameterMocks[0].ParameterName);
Assert.AreEqual("Param1", commandMock.ParameterMocks[0].Value);
Assert.AreEqual("1", commandMock.ParameterMocks[1].ParameterName);
Assert.AreEqual(123, commandMock.ParameterMocks[1].Value);
}
