I have a WCF service multiple UIs consume. When the user is unable to access the database, I get Unauthorised exception from the DB. I don't catch the exception on the server side and send it to the client.
On the client (asp.net webpage), I get to see the exception - User was unable to access the database, login failed. This is all good. But... if I make a call to the WCF service again, I get the exception that the service is in faulted state. Only open is to restart the entire WCF service. WCF service is hosted as a windows service.
What is the best way to catch the exceptions, log the exception on server side, send the exception details back to the client without breaking the service? Thanks