I am looking for some advice or guidance on catching errors when working with ADO.net and SQL server. Most examples and books, show code like
catch (Exception ex)
That works fine, however, I have never liked catching "Exception". What is the best practice when catching exceptions in regard to ADO.Net?