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)); }