ADO.NET is really good at managing the providers, so SQL or ORACLE won't make a difference on the design, if you designed the app to be working in SQL, by changing the provider won't change how to design. I would recommend to use the using{} to clean up your connections and make sure they are all back to the pools after using them
Cheers
Al
My BlogGeoTwitter.NETPlease click on 'Mark as Answer' if this post answered your question!