Click here to Skip to main content
15,902,276 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford5-Jul-07 13:01
rokford5-Jul-07 13:01 
GeneralRe: The best architecture solution for working with multiple data sources Pin
Urs Enzler8-Jul-07 2:59
Urs Enzler8-Jul-07 2:59 
AnswerRe: The best architecture solution for working with multiple data sources Pin
nitikin2-Jul-07 0:58
nitikin2-Jul-07 0:58 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford2-Jul-07 2:44
rokford2-Jul-07 2:44 
AnswerRe: The best architecture solution for working with multiple data sources Pin
led mike2-Jul-07 4:55
led mike2-Jul-07 4:55 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford2-Jul-07 15:06
rokford2-Jul-07 15:06 
AnswerRe: The best architecture solution for working with multiple data sources Pin
Pete O'Hanlon2-Jul-07 9:49
mvePete O'Hanlon2-Jul-07 9:49 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford2-Jul-07 17:32
rokford2-Jul-07 17:32 
From my point of view accessing a data source and retrieving data is the task that can be formalized quite well. ADO.NET is a good example of this. Unlike ADO.NET we plan to implement some middle tier that will common for all applications (developers). So the main task is to access different data sources using some abstract model. You should not think that application "knows nothing" about database - it knows enough to get required information from database. But there will not be connection strings, stored procedures ,etc.


"Another issue, is that there really does come a time when your application needs to know what the data source is. For instance, you may want to insert a record into a database that has an automatically incremented primary key - but not all databases support this, so you need to have some mechanism to generate the key for this database."

In our company we always use stored procedure instead of direct sql statements. So in this case there must be a procedure like "insert_something" that hides away how primary key is generated - with auto increment or using sequences.Of course,it's implementation will depend on what database is being using, but at the same time it will transparent to client applications.
So we do not want to create some universal language for all databases- but organize all these databases (connection strings,user credentials,stored procedures,ets) is some abstract model and make it accessible by all applications using different protocols and communication technologies (due to WCF)
GeneralRe: The best architecture solution for working with multiple data sources Pin
Pete O'Hanlon2-Jul-07 22:43
mvePete O'Hanlon2-Jul-07 22:43 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford4-Jul-07 1:46
rokford4-Jul-07 1:46 
GeneralRe: The best architecture solution for working with multiple data sources Pin
led mike3-Jul-07 4:50
led mike3-Jul-07 4:50 
GeneralRe: The best architecture solution for working with multiple data sources Pin
rokford4-Jul-07 1:15
rokford4-Jul-07 1:15 
QuestionWhat is the best possible Design Pattern Pin
JoeContreras27-Jun-07 13:01
JoeContreras27-Jun-07 13:01 
AnswerRe: What is the best possible Design Pattern Pin
nitikin2-Jul-07 1:05
nitikin2-Jul-07 1:05 
GeneralRe: What is the best possible Design Pattern Pin
JoeContreras2-Jul-07 7:07
JoeContreras2-Jul-07 7:07 
QuestionLibrary Architecture for Multiple Applications and Multiple Developers [modified] Pin
brmorris26-Jun-07 15:42
brmorris26-Jun-07 15:42 
AnswerRe: Library Architecture for Multiple Applications and Multiple Developers Pin
Chris-Kaiser10-Jul-07 16:40
Chris-Kaiser10-Jul-07 16:40 
Questionvirtual functions Pin
tom groezer25-Jun-07 9:42
tom groezer25-Jun-07 9:42 
AnswerRe: virtual functions Pin
Pete O'Hanlon25-Jun-07 10:24
mvePete O'Hanlon25-Jun-07 10:24 
GeneralRe: virtual functions Pin
nitikin2-Jul-07 1:23
nitikin2-Jul-07 1:23 
GeneralRe: virtual functions Pin
Pete O'Hanlon2-Jul-07 3:23
mvePete O'Hanlon2-Jul-07 3:23 
Questiontransparency on IE Pin
xxrono25-Jun-07 1:12
xxrono25-Jun-07 1:12 
AnswerRe: transparency on IE Pin
Pete O'Hanlon25-Jun-07 2:10
mvePete O'Hanlon25-Jun-07 2:10 
QuestionHelp needed to end the madness. Pin
daviiie23-Jun-07 0:11
daviiie23-Jun-07 0:11 
AnswerRe: Help needed to end the madness. Pin
Pete O'Hanlon25-Jun-07 2:26
mvePete O'Hanlon25-Jun-07 2:26 

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.