Making an enterprise app database independent...
-
Any pointers, suggestions, links, hints on making an enterprise app database independent... Thanks… Salil Khedkar [^]
-
Any pointers, suggestions, links, hints on making an enterprise app database independent... Thanks… Salil Khedkar [^]
Have a look at the Data Provider model (DotNetNuke[^] has a good example).
My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
-
Any pointers, suggestions, links, hints on making an enterprise app database independent... Thanks… Salil Khedkar [^]
There are OOP design patterns that allow you to completely decouple an application from various parts of it's implementation, including database implementation. Basically you would define an abstract interface that describes database operations in a standard, high level, platform independent fashion. Then you use a pattern known as an Abstract Factory to create the classes that actually provide the platform specific database implementation. Having said that, it;s easy to describe the concept, the implementation is another matter altogether. :-) I suggest you get a good book, or several that describe Design Patterns for the language you are using and be prepared to spend a lot of time studying and experimenting.
-
There are OOP design patterns that allow you to completely decouple an application from various parts of it's implementation, including database implementation. Basically you would define an abstract interface that describes database operations in a standard, high level, platform independent fashion. Then you use a pattern known as an Abstract Factory to create the classes that actually provide the platform specific database implementation. Having said that, it;s easy to describe the concept, the implementation is another matter altogether. :-) I suggest you get a good book, or several that describe Design Patterns for the language you are using and be prepared to spend a lot of time studying and experimenting.
Hmmm... Thanks for the info man... Yup I am starting the study phase... :) Salil Khedkar [^]
-
Have a look at the Data Provider model (DotNetNuke[^] has a good example).
My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
Hmmm... Thanks for the info... O/R mapper seems to be the keyword for this subject. I will read more... Salil Khedkar [^]