Posted By

rengber on 11/19/08

Tagged

Versions (?)

Last Edited at 11/19/08 09:32pm

Statistics

Viewed 885 times

Favorited by 0 user(s)

Related snippets

Using NMock to Create an IDataReader for Testing Data Access Methods

/ Published in: C#

Shows how to mock the Object["CollectionItemName"] syntax.

Highlighted TextExpand

public class TransactionStore
{
	public virtual IDataReader GetReader(SqlCommand cmd)
	{
	  return cmd.ExecuteReader(); 
	}

public decimal GetAvailableBalance(int custNumb)
	{
	  decimal retVal = 0.00M; 
	  using (SqlConnection sqlConnection = new SqlConnection(_dbConnection))
	  {
		sqlConnection.Open();
		using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
		{
		  sqlCommand.CommandType = CommandType.StoredProcedure;
		  sqlCommand.CommandText = "dbo.GetCustomerBalance";
		  sqlCommand.Parameters.AddWithValue("CustomerID", custNumb);
		  using (IDataReader dr = GetReader(sqlCommand))
		  {
			if (dr != null)
			{
			  dr.Read();
			  retVal = Convert.ToDecimal(dr["AvailableBalance"]);
			}
		  }
		}
	  }
	  return retVal; 
	}
}

[TestFixture]
public class IMTTests : TransactionStore
{
	Mockery mocks = new Mockery(); 
	IDataReader idr = null;

public override IDataReader GetReader(SqlCommand cmd)
	{
	  Expect.AtLeastOnce.On(idr).Method("Read").Will(Return.Value(true));
	  Expect.AtLeastOnce.On(idr).Method("Dispose"); 
	  return idr; 
	}
  
	[Test]
	public void TestAvailableBalance()
	{
	  idr = (IDataReader)mocks.NewMock(typeof(IDataReader));
	  Expect.AtLeastOnce.On(idr).Get["AvailableBalance"].Will(Return.Value(42.00M));
	  Decimal amount = this.GetAvailableBalance(12345);
	  Assert.AreEqual(42.00M, amount); 
	}
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.