I have an app that is reading and writing from databases that are structurally identical but are from different systems, primarily SQL Server and Access 2010. When using the respective .Net objects such as connections, commands, datareaders,
the code seems to be often the same (except for transactions - Access doesn't do transactions?). But the objects are different - sqlconnection versus oledbconnection, etc.
Is there a standard way of writing data access code that works regardless of the database type?
View Complete Post