Click here to Skip to main content
15,900,378 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
QuestionBest Practices for Code Organization Pin
minus_one30-Oct-08 21:37
minus_one30-Oct-08 21:37 
AnswerRe: Best Practices for Code Organization Pin
Urs Enzler2-Nov-08 0:20
Urs Enzler2-Nov-08 0:20 
AnswerRe: Best Practices for Code Organization Pin
Eddy Vluggen2-Nov-08 22:52
professionalEddy Vluggen2-Nov-08 22:52 
QuestionMultiple database support Pin
Atul Kharecha30-Oct-08 0:40
Atul Kharecha30-Oct-08 0:40 
AnswerRe: Multiple database support Pin
Giorgi Dalakishvili30-Oct-08 1:16
mentorGiorgi Dalakishvili30-Oct-08 1:16 
AnswerRe: Multiple database support Pin
Urs Enzler2-Nov-08 0:22
Urs Enzler2-Nov-08 0:22 
AnswerRe: Multiple database support Pin
Giorgi Dalakishvili3-Nov-08 8:06
mentorGiorgi Dalakishvili3-Nov-08 8:06 
RantRe: Multiple database support Pin
Jessn9-Dec-08 10:38
Jessn9-Dec-08 10:38 
heyitsAtul wrote:
Hi,

Can anyone suggest how to design application, which support multiple databases (like SQL Server, Oracle) and with minimum change, we can shift database from one to another.

Thanks.


It can be done in several ways. First of all you need to have an abstraction layer. That layer needs to be a generic layer that matches the interface for both databases. Secondarily, I'll recommend that use a factory. Try to take a look at the following link for inspiration

Connection pool[^]

Hth

--
Jess Nielsen, b.sc.
Security Analyst

http://jessn.blogspot.com/

AnswerRe: Multiple database support... example [modified] Pin
Jessn9-Dec-08 10:40
Jessn9-Dec-08 10:40 
GeneralReplicating Business Rules on a Web Client Pin
Brady Kelly28-Oct-08 0:00
Brady Kelly28-Oct-08 0:00 
GeneralRe: Replicating Business Rules on a Web Client Pin
Ray Cassick4-Nov-08 10:51
Ray Cassick4-Nov-08 10:51 
GeneralRe: Replicating Business Rules on a Web Client Pin
Mark Churchill4-Nov-08 12:25
Mark Churchill4-Nov-08 12:25 
QuestionPatterns Pin
CodingYoshi23-Oct-08 3:57
CodingYoshi23-Oct-08 3:57 
AnswerRe: Patterns Pin
Leslie Sanford23-Oct-08 11:52
Leslie Sanford23-Oct-08 11:52 
AnswerRe: Patterns Pin
Mark Churchill23-Oct-08 13:36
Mark Churchill23-Oct-08 13:36 
GeneralRe: Patterns Pin
CodingYoshi24-Oct-08 3:38
CodingYoshi24-Oct-08 3:38 
GeneralRe: Patterns Pin
Urs Enzler2-Nov-08 0:30
Urs Enzler2-Nov-08 0:30 
GeneralRe: Patterns Pin
Mark Churchill2-Nov-08 14:22
Mark Churchill2-Nov-08 14:22 
GeneralRe: Patterns Pin
Urs Enzler2-Nov-08 20:56
Urs Enzler2-Nov-08 20:56 
AnswerRe: Patterns Pin
Samer Aburabie17-Nov-08 12:05
Samer Aburabie17-Nov-08 12:05 
Questionin search of a better printing/reporting mechanism Pin
giddy_guitarist19-Oct-08 0:56
giddy_guitarist19-Oct-08 0:56 
AnswerRe: in search of a better printing/reporting mechanism Pin
User 171649223-Oct-08 9:51
professionalUser 171649223-Oct-08 9:51 
AnswerRe: in search of a better printing/reporting mechanism Pin
Mycroft Holmes15-Nov-08 23:22
professionalMycroft Holmes15-Nov-08 23:22 
GeneralRe: in search of a better printing/reporting mechanism Pin
giddy_guitarist16-Nov-08 0:34
giddy_guitarist16-Nov-08 0:34 
QuestionForm Template - requirement gathering Pin
iamshaan13-Oct-08 5:12
iamshaan13-Oct-08 5:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.