Where is the optimal place to implement SQL retry logic when using ASP.Net TableAdapters?
<p>I'm using Visual Studio 2010, TableAdapters, and writing my code in C#.  I'm currently venturing into debugging my code after having written some data population code and I'm looking through what SQL issues I'm encountering.  At this point I want to implement some SQL retry code to handle retrying any queries if they timeout for various reason.  I can implmement them in my business logic layer but then I'd be duplicating that code in all of the BLL methods that call into my TableAdapters.  I believe I need to do this at the TableAdapter level or even somewhere higher as I have on the order of 30 or so different TableAdapters corresponding to different data.  Does anyone have any sample code on implementing code that will be run by all TableAdapters?  I have seen sample code on extending TableAdapters but I'm looking for something even more centralized for retry logic.</p>
