Click here to Skip to main content
11,479,170 members (53,731 online)

Design and Architecture

 
GeneralRe: Abstract factory Pin
Shameel17-May-11 5:21
memberShameel17-May-11 5:21 
GeneralRe: Abstract factory Pin
Phil00520-May-11 23:09
memberPhil00520-May-11 23:09 
QuestionUML state diagrams Pin
Phil00510-May-11 8:39
memberPhil00510-May-11 8:39 
AnswerRe: UML state diagrams Pin
Gerben Jongerius10-May-11 22:19
memberGerben Jongerius10-May-11 22:19 
GeneralRe: UML state diagrams Pin
Phil00515-May-11 2:22
memberPhil00515-May-11 2:22 
AnswerRe: UML state diagrams Pin
Keld Ølykke24-May-11 4:16
memberKeld Ølykke24-May-11 4:16 
GeneralRe: UML state diagrams Pin
Phil00527-May-11 2:04
memberPhil00527-May-11 2:04 
QuestionStored Procedures Pin
Leslie Sanford9-May-11 18:38
memberLeslie Sanford9-May-11 18:38 
I was wondering what the best practises are for stored procedures. Basically, I'm still struggling with a kind of code explosion that occurs when writing code that's related to the database. In the end, what I need to do is move data into and out of the database while sometimes performing transformations and doing error checking along the way. I've found over and over again that it takes a lot of code to do this.

I'm curious if stored procedures are a good way to abstract out of code such things as queries, inserts, updates, etc., and move them into the database itself.

In a way, this relates to a thread I created here a few months ago about database code. I'm trying to get a handle on how to deal with complexity. I'm finding that database programming is largely procedureal in nature, so I'm not finding my experience with Object Oriented programming and patterns to be of much use.
AnswerRe: Stored Procedures Pin
Gerben Jongerius10-May-11 22:27
memberGerben Jongerius10-May-11 22:27 
AnswerRe: Stored Procedures Pin
jschell24-May-11 9:43
memberjschell24-May-11 9:43 
QuestionThinking about the Future Pin
John D. Sanders6-May-11 9:53
memberJohn D. Sanders6-May-11 9:53 
AnswerRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 10:26
mvpPete O'Hanlon6-May-11 10:26 
GeneralRe: Thinking about the Future Pin
S Mewara6-May-11 18:41
mvpS Mewara6-May-11 18:41 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon6-May-11 23:39
mvpPete O'Hanlon6-May-11 23:39 
GeneralRe: Thinking about the Future Pin
paul_7114-May-11 23:56
memberpaul_7114-May-11 23:56 
GeneralRe: Thinking about the Future Pin
Pete O'Hanlon17-May-11 2:23
mvpPete O'Hanlon17-May-11 2:23 
AnswerRe: Thinking about the Future Pin
RobCroll6-May-11 17:51
memberRobCroll6-May-11 17:51 
AnswerRe: Thinking about the Future Pin
Shameel9-May-11 3:33
memberShameel9-May-11 3:33 
AnswerRe: Thinking about the Future Pin
weberrich31-May-11 6:55
memberweberrich31-May-11 6:55 
GeneralRe: Thinking about the Future Pin
John D. Sanders31-May-11 8:06
memberJohn D. Sanders31-May-11 8:06 
QuestionAbout Three -Tier and N-tier Architecture? Pin
maruthimaru29-Apr-11 23:58
membermaruthimaru29-Apr-11 23:58 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
DaveAuld30-Apr-11 0:08
memberDaveAuld30-Apr-11 0:08 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Sandeep Mewara30-Apr-11 1:22
mvpSandeep Mewara30-Apr-11 1:22 
AnswerRe: About Three -Tier and N-tier Architecture? Pin
Legor5-May-11 4:35
memberLegor5-May-11 4:35 
QuestionMVC Implementation Question Pin
Roger Wright25-Apr-11 19:13
memberRoger Wright25-Apr-11 19:13 

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

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


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 21 May 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid