I am trying to find out the best way of handling exceptions, I have a number of layers to my application and started to use a return type of BOOL i.e. if it fails then return False and if it succeeds return True..
This works great in methods like SaveMyRecord(somerecord); as i am passing in values and don't require anything returned so i can use the return type of bool to indicate if it succeeds or not.
But then it got me thinking that things like GetMyRecord() actually returns type of IQueryable hence i can't use a bool to tell me if it failed or not.
The thing is i am handle alot of my errors where they happen with try and catch and hence don't want the client to receive an exception.
Maybe there is a better way, i then got thinking about using OUT parameters BUT this means i need to change the signature of all methods and add aditional params..
Maybe i should be passing the exception back to the CLIENT and handling it there?
I am a little lost,
Is there some standards or any docs to adivse best practices?