ASP.NET: How to support two database types in one application? (Access, MS SQL Server 2008 Express)?

Yes, from framework 2.0 all data readers inherit from the DbDataReader class, so your methods could take a DbDataReader isntead of an OleDbDataReader and you could use the methods with any database.

The link you're likely missing is the functionality of the DbProviderFactories class. Using this class (and associated helpers also in System.Data. Common), you can abstract the provider and use references to the base classes (such as DbConnection and DbCommand) to do the work.

It'd look something like this.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions