Databases
StackOverflow2013
Postsdbo
POUse of the Exception class in c#
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUse of the Exception class in c#
    text
    copied!<p>Errors that occur deep down in a data access layer or even higher up, (say within ADO.net operations for example) rarely make much sense to an end user. Simply bubbling these errors up to a UI and displaying them will usually achieve nothing except frustration for an end user.</p> <p>I have recently employed a basic technique for reporting errors such as this whereby I catch the error and at least add some user friendly text so that at least the end user understands what failed.</p> <p>To do this I am catching an exception within each specific function (say for example a fetch function in a data access layer), then raising a new error with user friendly text about the function that has failed and probably cause, but then embedding the original exception in the new exception as the "inner exception" of that new exception. </p> <p>This can then occur at each layer if necessary, each consumer of the lower level function adding it's own context to the error message, so that what reaches the UI is an increasingly user friendly error message.</p> <p>Once the error reaches the UI - if necessary - it can then iterate through the nested exceptions in order to display an error message that firstly tells the user which operation failed, but also provides a bit of technical information about what actually went wrong.</p> <p>e.g. </p> <blockquote> <p>"The list of customer names your requested could not be displayed."</p> <p>"Obtaining the list of customers you requested failed due to an error with the database."</p> <p>"There was an error connecting to the database when retrieving a list of customers"</p> <p>"Login failed for user xx"</p> </blockquote> <p>My question is this: Is this horribly inefficient (all those nested exceptions)? I suspect it is not best practice so what should I be doing to achieve the same thing - or should I in fact be trying to achieve something better?</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload