How to throw a SqlException when needed for mocking and unit testing?

by

I have a solution to this. I’m not sure whether it’s genius or madness.

The following code will create a new SqlException:

public SqlException MakeSqlException() {
    SqlException exception = null;
    try {
        SqlConnection conn = new SqlConnection(@"Data Source=.;Database=GUARANTEED_TO_FAIL;Connection Timeout=1");
        conn.Open();
    } catch(SqlException ex) {
        exception = ex;
    }
    return(exception);
}

which you can then use like so (this example is using Moq)

mockSqlDataStore
    .Setup(x => x.ChangePassword(userId, It.IsAny<string>()))
    .Throws(MakeSqlException());

so that you can test your SqlException error handling in your repositories, handlers and controllers.

Now I need to go and lie down.

More Related Contents:

  1. Html.Partial vs Html.RenderPartial & Html.Action vs Html.RenderAction
  2. Fake DbContext of Entity Framework 4.1 to Test
  3. Override Authorize Attribute in ASP.NET MVC
  4. How can I get my webapp’s base URL in ASP.NET MVC?
  5. New asp.net charting controls – will they work with MVC (eventually)?
  6. “The resource cannot be found.” error when there is a “dot” at the end of the url
  7. ASP.NET MVC – Getting QueryString values
  8. How to convert View Model into JSON object in ASP.NET MVC?
  9. MVC4 HTTP Error 403.14 – Forbidden
  10. ASP.NET MVC – Find Absolute Path to the App_Data folder from Controller
  11. Cannot attach the file *.mdf as database
  12. How to create a CheckBoxListFor extension method in ASP.NET MVC?
  13. Retrieve the current view name in ASP.NET MVC?
  14. Using scripts in a master page with ASP.NET MVC
  15. Where and how is the _ViewStart.cshtml layout file linked?
  16. Can’t find ADO.net Entity Data Model template in VS2017
  17. What does Html.HiddenFor do?
  18. ASP.NET MVC security patch to version 3.0.0.1 breaks build [duplicate]
  19. Where to run a duplicate check for an entity
  20. What’s the difference between RouteLink and ActionLink in ASP.NET MVC?
  21. ASP .NET MVC Forms authorization with Active Directory groups
  22. How do I improve ASP.NET MVC application performance?
  23. Could not load file or assembly ‘Antlr3.Runtime (1)’ or one of its dependencies
  24. How to send an email with attachments using SmtpClient.SendAsync?
  25. ASP.Net MVC Redirect To A Different View
  26. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  27. How do I solve an AntiForgeryToken exception that occurs after an iisreset in my ASP.Net MVC app?
  28. ASP.NET MVC on IIS6
  29. How to Convert Row to Column in Linq and SQL
  30. How can I force a hard refresh (ctrl+F5)?

Leave a Comment