Answer: Microsoft Application Blocks For ODBC
The one for SQL works great but it only works for SQL, not other DBs.
The one for SQL works great but it only works for SQL, not other DBs.
Check out the new Data Access Application Block available at the link below. This block abstracts the Database and provides you out of the box with SqlDatabase, OracleDatabase and Db2Database classes.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp
Gary Blatt wrote a great article to prime you up on the Enterprise Library located here:
http://www.dotnetjunkies.com/Tutorial/29EF3A4F-A0C2-4BB2-A215-8F87F100A9F9.dcik
- David Sandor
Also, is there anything specifically for Microsoft Access? I have a number of Access DB's I need to connect to but can't convert them to SQL (Or anything else for that matter).
I would rather not spend time building a class to use OleDB instead of SQLClient if I don't have to.
Thanks for the links.