Moq – Mocking the Request context and verifying SQLException is raised.

Posted on by

Mocking the Request on an API Controller

Had an API controller under unit test which made use of the HttpMessageRequest which I needed to mock.How do I get a handle on this?

Again pretty simple really (my initial train of thought was back to front on this one)

var request = new HttpMessageRequest(HttpMethod.Get, "http://....."
controllerUnderTest.request = request;

Verifying that a SQLException is raised.



I was unable to mock

.Throws<<"SQLException">>

as SQLException has a parameterless constructor as in….

‘System.Data.SqlClient.SqlException’ must be a non-abstract type with a public parameterless constructor in order to use it as parameter ‘TException’ in the generic type or method ‘Moq.Language.IThrows.Throws()’

So what to do?

var exception = FormatterServices.GetUninitializedObject(typeof(SqlException)) as SqlException;
mockInvalidDBContext.Setup(d => d.GetConnection()).Throws(exception);

Credit to http://stackoverflow.com/questions/11976996/moq-and-throwing-a-sqlexception