public void Constructor_CreatesConnection_ReturnsCommandWithCorrectTransaction() {
var dataSource = A.Fake<IDataSource>();
var dbCommand = A.Fake<IDbCommand>();
var dbTransaction = TransactionFactory.BeginTransaction(dataSource);
var command = new Command(dbCommand, dbTransaction, null);
Assert.AreEqual(dbTransaction, command.Transaction);
Assert.AreEqual(dbTransaction.Connection, dbCommand.Connection);
Assert.AreEqual(dbTransaction.DbTransaction, dbCommand.Transaction);
}
public void AddInParameter_CreateParameterWithNameAndType_CorrectParameterAdded() {
var dbCommand = A.Fake<IDbCommand>();
var parameterCollection = A.Fake<IDataParameterCollection>();
A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
IDataParameter parameter = null;
A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);
var command = new Command(dbCommand, null, null);
command.AddInParameter("MyParameter", DbType.AnsiString);
Assert.IsNotNull(parameter);
Assert.AreEqual("MyParameter", parameter.ParameterName);
Assert.AreEqual(DbType.AnsiString, parameter.DbType);
Assert.AreEqual(ParameterDirection.Input, parameter.Direction);
}
public void AddInParameter_PassDataRowVersion_CorrectParameterAdded() {
var dbCommand = A.Fake<IDbCommand>();
var parameterCollection = A.Fake<IDataParameterCollection>();
A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
IDataParameter parameter = null;
A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);
var command = new Command(dbCommand, null, null);
command.AddInParameter("MyParameter", DbType.DateTime2, "column", DataRowVersion.Proposed);
Assert.IsNotNull(parameter);
Assert.AreEqual("MyParameter", parameter.ParameterName);
Assert.AreEqual(DbType.DateTime2, parameter.DbType);
Assert.AreEqual("column", parameter.SourceColumn);
Assert.AreEqual(DataRowVersion.Proposed, parameter.SourceVersion);
Assert.AreEqual(ParameterDirection.Input, parameter.Direction);
}
public void Dispose_PassingDbCommand_UnderlyingCommandMustHaveBeenDisposed() {
var dbCommand = A.Fake<IDbCommand>();
var command = new Command(dbCommand, null, null);
command.Dispose();
A.CallTo(() => dbCommand.Dispose()).MustHaveHappened();
}
public void CommandText_PassingCommandWithCommandTimeout_ReturnsCorrectTimeout() {
var dbCommand = A.Fake<IDbCommand>();
dbCommand.CommandTimeout = 120;
var command = new Command(dbCommand, null, null);
Assert.AreEqual(120, command.CommandTimeout);
command.CommandTimeout = 60;
Assert.AreEqual(60, command.DbCommand.CommandTimeout);
}
public void CommandText_PassingCommandWithCommandText_ReturnsCorrectText() {
var dbCommand = A.Fake<IDbCommand>();
dbCommand.CommandText = "Command text";
var command = new Command(dbCommand, null, null);
Assert.AreEqual("Command text", command.CommandText);
command.CommandText = "New Command Text";
Assert.AreEqual("New Command Text", command.DbCommand.CommandText);
}
public void AddParameter_CreateParameter_CorrectParameterAdded() {
var dbCommand = A.Fake<IDbCommand>();
var parameterCollection = A.Fake<IDataParameterCollection>();
A.CallTo(() => dbCommand.Parameters).Returns(parameterCollection);
IDataParameter parameter = null;
A.CallTo(() => parameterCollection.Add(A<object>.Ignored)).WithAnyArguments().Invokes(x => parameter = x.GetArgument<IDataParameter>(0)).Returns(1);
var command = new Command(dbCommand, null, null);
var dummyObject = A.Dummy<MyDummyClass>();
command.AddParameter("MyParameter", DbType.Guid, 242, ParameterDirection.InputOutput, 1, 1, "myColumn", DataRowVersion.Original, dummyObject);
IDbDataParameter dbParamter = parameter as IDbDataParameter;
Assert.IsNotNull(dbParamter);
Assert.AreEqual("MyParameter", dbParamter.ParameterName);
Assert.AreEqual(DbType.Guid, dbParamter.DbType);
Assert.AreEqual(ParameterDirection.InputOutput, dbParamter.Direction);
Assert.AreEqual(242, dbParamter.Size);
Assert.AreEqual(DataRowVersion.Original, dbParamter.SourceVersion);
Assert.AreEqual(1, dbParamter.Precision);
Assert.AreEqual(1, dbParamter.Scale);
Assert.AreEqual("myColumn", dbParamter.SourceColumn);
Assert.AreEqual(dummyObject, dbParamter.Value);
}