[Dotnetmock-developer] dotnetmock/DotNetMock.Tests/data mockcommandtests.cs,NONE,1.1

[<gc...@us...>]

Update of /cvsroot/dotnetmock/dotnetmock/DotNetMock.Tests/data
In directory usw-pr-cvs1:/tmp/cvs-serv24069/DotNetMock.Tests/data

Added Files:
	mockcommandtests.cs 
Log Message:



--- NEW FILE: mockcommandtests.cs ---
using System;
using System.Data;
using NUnit.Framework;
using DotNetMock.Data;

namespace DotNetMock.Tests.Data
{
	/// <summary>
	/// Summary description for MockCommandTests.
	/// </summary>
	[TestFixture]
	public class MockCommandTests
	{
		private MockCommand _mockCmd = null;
		[TearDown]
		public void Destroy()
		{
			_mockCmd.Dispose();
			_mockCmd = null;
		}
		[Test]
		public void CommandTextProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandText(@"user id=sa;password=password;Connect Timeout=30");
			_mockCmd.CommandText = @"user id=sa;password=password;Connect Timeout=30";
			_mockCmd.Verify();
		}
		[Test]
		[ExpectedException(typeof(AssertionException))]
		public void InValidCommandTextProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandText(@"user id=sa;password=password;Connect Timeout=30");
			_mockCmd.Verify();
		}
		[Test]
		public void CommandTimeoutProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandTimeout(0);
			_mockCmd.CommandTimeout = 0;
			_mockCmd.Verify();
		}
		[Test]
		[ExpectedException(typeof(NotImplementedException))]
		public void InValidCommandTimeoutProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandTimeout(30);
			_mockCmd.CommandTimeout = 30;
			_mockCmd.Verify();
		}
		[Test]
		public void CommandTypeProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandType(System.Data.CommandType.Text);
			_mockCmd.CommandType = System.Data.CommandType.Text;
			_mockCmd.Verify();
		}
		[Test]
		[ExpectedException(typeof(NotImplementedException))]
		public void InValidCommandTypeProperty()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedCommandType(System.Data.CommandType.StoredProcedure);
			_mockCmd.CommandType = System.Data.CommandType.StoredProcedure;
			_mockCmd.Verify();
		}
		[Test]
		public void ConnectionProperty()
		{
			_mockCmd = new MockCommand();
			MockDbConnection mockConnection = new MockDbConnection();
			MockTransaction mockTransaction = new MockTransaction();

			NUnit.Framework.Assertion.AssertNull(_mockCmd.Connection);
			_mockCmd.Transaction = mockTransaction;
			NUnit.Framework.Assertion.AssertNotNull(_mockCmd.Transaction);
			_mockCmd.Connection = mockConnection;
			NUnit.Framework.Assertion.AssertNotNull(_mockCmd.Connection);
			NUnit.Framework.Assertion.AssertEquals(typeof(MockDbConnection), _mockCmd.Connection.GetType());
		}
		[Test]
		public void ParametersProperty()
		{
			_mockCmd = new MockCommand();
			MockDataParameter mockParameter = new MockDataParameter("@inpID", "123456");
			_mockCmd.SetExpectedParameter(mockParameter);
			_mockCmd.Parameters.Add(mockParameter);
			_mockCmd.Verify();
			NUnit.Framework.Assertion.AssertEquals(typeof(MockDataParameterCollection), _mockCmd.Parameters.GetType());
		}
		[Test]
		[ExpectedException(typeof(AssertionException))]
		public void InValidParametersProperty()
		{		
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedParameter(new MockDataParameter("@inpID", "123456"));
			_mockCmd.Verify();
		}	
		[Test]
		public void ExecuteCalls()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedExecuteCalls(5);
			_mockCmd.ExecuteNonQuery();
			_mockCmd.ExecuteReader();
			_mockCmd.ExecuteScalar();
			_mockCmd.ExecuteScalar();
			_mockCmd.ExecuteNonQuery();
			_mockCmd.Verify();
		}
		[Test]
		[ExpectedException(typeof(AssertionException))]
		public void InValidExecuteCalls()
		{
			_mockCmd = new MockCommand();
			_mockCmd.SetExpectedExecuteCalls(2);
			_mockCmd.ExecuteNonQuery();
			_mockCmd.Verify();
		}
	}
}