Click here to Skip to main content
15,891,136 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Abstract factory Pin
Phil00520-May-11 22:09
Phil00520-May-11 22:09 
QuestionUML state diagrams Pin
Phil00510-May-11 7:39
Phil00510-May-11 7:39 
AnswerRe: UML state diagrams Pin
Gerben Jongerius10-May-11 21:19
Gerben Jongerius10-May-11 21:19 
GeneralRe: UML state diagrams Pin
Phil00515-May-11 1:22
Phil00515-May-11 1:22 
AnswerRe: UML state diagrams Pin
Keld Ølykke24-May-11 3:16
Keld Ølykke24-May-11 3:16 
GeneralRe: UML state diagrams Pin
Phil00527-May-11 1:04
Phil00527-May-11 1:04 
QuestionStored Procedures Pin
Leslie Sanford9-May-11 17:38
Leslie Sanford9-May-11 17:38 
AnswerRe: Stored Procedures Pin
Gerben Jongerius10-May-11 21:27
Gerben Jongerius10-May-11 21:27 
I believe that the database and the stored procedures, or functions should only be used to guard data constraints. So they can be useful when you insert data into one row that always needs to be verified against another table, when a foreign key alone does not describe the full nature of the relation. For example one row depends on a range of rows existings in a foreign key. Another good reason to use them is to guarentee sequential execution of data insertion or deletion across multiple instances of the application.

From what I understand from your question you might be better of abstracting inside the code first by generating generic classes responsible specific parst of the applictions communicating with the database.
AnswerRe: Stored Procedures Pin
jschell24-May-11 8:43
jschell24-May-11 8:43 
QuestionThinking about the Future Pin
John D. Sanders6-May-11 8:53
John D. Sanders6-May-11 8:53 
AnswerRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 9:26
mvePete O'Hanlon6-May-11 9:26 
GeneralRe: Thinking about the Future Pin
Sandeep Mewara6-May-11 17:41
mveSandeep Mewara6-May-11 17:41 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 22:39
mvePete O'Hanlon6-May-11 22:39 
GeneralRe: Thinking about the Future Pin
Paul Michalik14-May-11 22:56
Paul Michalik14-May-11 22:56 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon17-May-11 1:23
mvePete O'Hanlon17-May-11 1:23 
AnswerRe: Thinking about the Future Pin
RobCroll6-May-11 16:51
RobCroll6-May-11 16:51 
AnswerRe: Thinking about the Future Pin
Shameel9-May-11 2:33
professionalShameel9-May-11 2:33 
AnswerRe: Thinking about the Future Pin
weberrich31-May-11 5:55
weberrich31-May-11 5:55 
GeneralRe: Thinking about the Future Pin
John D. Sanders31-May-11 7:06
John D. Sanders31-May-11 7:06 
QuestionAbout Three -Tier and N-tier Architecture? Pin
maruthimaru29-Apr-11 22:58
maruthimaru29-Apr-11 22:58 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
DaveAuld29-Apr-11 23:08
professionalDaveAuld29-Apr-11 23:08 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Sandeep Mewara30-Apr-11 0:22
mveSandeep Mewara30-Apr-11 0:22 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Legor5-May-11 3:35
Legor5-May-11 3:35 
QuestionMVC Implementation Question Pin
Roger Wright25-Apr-11 18:13
professionalRoger Wright25-Apr-11 18:13 
AnswerRe: MVC Implementation Question Pin
Legor5-May-11 3:29
Legor5-May-11 3:29 

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.