Home  /  Questions  /  Question

65   95.8
May 28, 2014

Design pattern to implementing different database?


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 ?


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.

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

I hope this makes sense. 

King Wilder