I think you can do something like this. Put a Key Value pair in web.config which holds some value that defines what database needs to be connected to. Design your Data Access Layer such that the it checks for that value if value says Access database use OleDb objects to handle the db operations else if value says SQL server database use Sql objects to handle the db operations.
I think that might be the most generic way. On Nov 23, 5:31 pm, jack me <[email protected]> wrote: > Hi, > > I have to create a website, but according to some standards. > > - it should be compatible with any database with minimal changes, I googled > and found that i need to implement abstract factory pattern. I have not used > that. > > tell me Am I on right way ? > > any link Where I can found some information about this ..? > > regards,
