public void ExecuteScalar_PassingNullCommand_ThrowsArgumentNullException() {
var provider = A.Fake<IProvider>();
var dataSource = new DataSource(provider);
Assert.Throws<ArgumentNullException>(() => dataSource.ExecuteScalar((ICommand)null));
}
public void ExecuteScalar_ExecuteSp_ReturnsDataset() {
var provider = A.Fake<IProvider>();
var dataSource = new DataSource(provider);
var dbCommand = A.Fake<IDbCommand>();
var dummyObject = A.Fake<MyDummyClass>();
A.CallTo(() => provider.CreateCommand()).Returns(dbCommand);
A.CallTo(() => dbCommand.ExecuteScalar()).Returns(dummyObject);
var result = dataSource.ExecuteScalar("command");
Assert.AreEqual(dummyObject, result);
}
public void ExecuteScalar_ExecuteCommandWithoutTransaction_TransactionCreatedAfterExecute() {
var provider = A.Fake<IProvider>();
var command = A.Fake<ICommand>();
var dataSource = new DataSource(provider);
command.Transaction = null;
dataSource.ExecuteScalar(command);
Assert.IsNotNull(command.Transaction);
}
public void ExecuteScalar_ExecuteSpWithParameters_ReturnsDataset() {
var provider = A.Fake<IProvider>();
var dataAdapter = A.Fake<IDbDataAdapter>();
var dataSource = new DataSource(provider);
var dbCommand = A.Fake<IDbCommand>();
A.CallTo(() => provider.CreateDataAdapter()).Returns(dataAdapter);
A.CallTo(() => provider.CreateCommand()).Returns(dbCommand);
var parameters = A.CollectionOfFake<IDataParameter>(12).ToArray();
dataSource.ExecuteScalar("spname", parameters);
A.CallTo(() => dbCommand.Parameters.Add(A<object>.Ignored)).MustHaveHappened(Repeated.Exactly.Times(12));
}
