Mock SQLConnection

Hi,
It depends how your code is written here is a small example.
You should read the documentation about how to set up expectations:
(Taken from another post)

MockManager.Init();
// mock the next sqlConnection instance
m_MockConnection = MockManager.Mock(typeof(SqlConnection));

// expect a certain connection string (you can use Custom Parameter
// checkers to do a dynamic check)
m_MockConnection.ExpectConstructor().Args("your connection string");

// mock Open, you can mock throwing an exception by using
// ExpectAndThrow("Open",new SqlException())
m_MockConnection.ExpectCall("Open");

// Mock State and return Open
m_MockConnection.ExpectGet("State",ConnectionState.Open);
         
// Mock the next sqlCommand instance
MockObject mockCommand = MockManager.Mock(typeof(SqlCommand));
// Create the mocked instancem, you can add expectations
SqlCommand command = new SqlCommand();

// return it when Connection.CreateCommand is called
m_MockConnection.ExpectAndReturn("CreateCommand",command);

Many thanks, excellent, it all makes sense now

I have been trying this and I think there is a problem with the examples you are showing.

ExpectAndThrow("Open",new SqlException()) 

This fails to compile because the constructor for SqlException is private. Is there any other way to mock the connection and test for an SqlException being thrown?

Never mind, I figured it out :wink: . It takes a bit of Reflection magic to accomplish thought.

         Mock mockConn = MockManager.Mock(typeof(SqlConnection));
         Type typeEx = typeof(SqlException);
         ConstructorInfo[] info = typeEx.GetConstructors(BindingFlags.Public | BindingFlags.Static | BindingFlags.NonPublic | BindingFlags.Instance );
         Object obj = info[0].Invoke(null);
         
         mockConn.ExpectAndThrow("Open", (SqlException)obj);

The BindingFlags are needed to get the non-public constructors for the object.