Home  /  Questions  /  Question



65   95.8
May 28, 2014


Design pattern to implementing different database?

Hi,

I need to design the application in such a way that it can handle different database as well extend the function in future to communicate with the external system also.

What design pattern should i follow ?

Thank.




588   99.9
Sep 21, 2014
I would create a separate Data Objects project for each data access layer you need, and then have a corresponding connectionString section in your web.config that points to the appropriate data access layer.

Example:
  1. Data Objects 1 would point to SQL Server
  2. Data Objects 2 would point to Oracle

I hope this makes sense. 

King Wilder