Click here to Skip to main content

Design and Architecture

 
GeneralRe: Data Fusion PinmemberTorstenH.13-Jun-11 21:06 
QuestionAbstract factory PinmemberPhil00515-May-11 1:37 
AnswerRe: Abstract factory PinmemberPhil00516-May-11 23:58 
AnswerRe: Abstract factory PinmemberDavid Skelly17-May-11 2:14 
GeneralRe: Abstract factory PinmvpRichard MacCutchan17-May-11 2:36 
GeneralRe: Abstract factory PinmemberPhil00517-May-11 3:06 
GeneralRe: Abstract factory PinmemberShameel17-May-11 4:21 
GeneralRe: Abstract factory PinmemberPhil00520-May-11 22:09 
QuestionUML state diagrams PinmemberPhil00510-May-11 7:39 
AnswerRe: UML state diagrams PinmemberGerben Jongerius10-May-11 21:19 
GeneralRe: UML state diagrams PinmemberPhil00515-May-11 1:22 
AnswerRe: UML state diagrams PinmemberKeld Ølykke24-May-11 3:16 
GeneralRe: UML state diagrams PinmemberPhil00527-May-11 1:04 
QuestionStored Procedures PinmemberLeslie Sanford9-May-11 17: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 PinmemberGerben Jongerius10-May-11 21:27 
AnswerRe: Stored Procedures Pinmemberjschell24-May-11 8:43 
QuestionThinking about the Future PinmemberJohn D. Sanders6-May-11 8:53 
AnswerRe: Thinking about the Future PinmvpPete O'Hanlon6-May-11 9:26 
GeneralRe: Thinking about the Future PinmvpS Mewara6-May-11 17:41 
GeneralRe: Thinking about the Future PinmvpPete O'Hanlon6-May-11 22:39 
GeneralRe: Thinking about the Future Pinmemberpaul_7114-May-11 22:56 
GeneralRe: Thinking about the Future PinmvpPete O'Hanlon17-May-11 1:23 
AnswerRe: Thinking about the Future PinmemberRobCroll6-May-11 16:51 
AnswerRe: Thinking about the Future PinmemberShameel9-May-11 2:33 
AnswerRe: Thinking about the Future Pinmemberweberrich31-May-11 5:55 
GeneralRe: Thinking about the Future PinmemberJohn D. Sanders31-May-11 7:06 
QuestionAbout Three -Tier and N-tier Architecture? Pinmembermaruthimaru29-Apr-11 22:58 
AnswerRe: About Three -Tier and N-tier Architecture? PinmemberDaveAuld29-Apr-11 23:08 
AnswerRe: About Three -Tier and N-tier Architecture? PinmvpSandeep Mewara30-Apr-11 0:22 
AnswerRe: About Three -Tier and N-tier Architecture? PinmemberLegor5-May-11 3:35 
QuestionMVC Implementation Question PinmemberRoger Wright25-Apr-11 18:13 
AnswerRe: MVC Implementation Question PinmemberLegor5-May-11 3:29 
QuestionPopulating Data Model Properties PinmemberKevin Marois25-Apr-11 5:36 
AnswerRe: Populating Data Model Properties Pinmember d@nish 25-Apr-11 5:45 
GeneralRe: Populating Data Model Properties PinmemberKevin Marois25-Apr-11 6:00 
GeneralRe: Populating Data Model Properties Pinmember d@nish 25-Apr-11 6:06 
GeneralRe: Populating Data Model Properties PinmemberSoulus8325-Apr-11 10:33 
AnswerRe: Populating Data Model Properties PinmemberMycroft Holmes25-Apr-11 12:59 
QuestionProcess Review: User Registration with Confirmation. PinmemberBrady Kelly18-Apr-11 7:35 
QuestionI have develop a web based Accounting and Inventory Software. How I can Market it? PinmemberPrasanta_Prince16-Apr-11 6:52 
AnswerRe: I have develop a web based Accounting and Inventory Software. How I can Market it? PinmemberLloyd Atkinson25-Apr-11 11:59 
AnswerRe: I have develop a web based Accounting and Inventory Software. How I can Market it? PinmvpSandeep Mewara30-Apr-11 0:24 
QuestionGood book for design principles Pinmembervariantseeker14-Apr-11 3:38 
AnswerRe: Good book for design principles PinmemberKeld Ølykke15-Apr-11 8:19 
QuestionDRY PinmemberMember 448708313-Apr-11 8:45 
AnswerRe: DRY PinmvpPete O'Hanlon13-Apr-11 9:09 
GeneralRe: DRY PinmemberMember 448708313-Apr-11 9:34 
GeneralRe: DRY PinmvpPete O'Hanlon13-Apr-11 9:51 
AnswerRe: DRY PinmemberEddy Vluggen13-Apr-11 10:25 
GeneralRe: DRY PinmvpPete O'Hanlon13-Apr-11 10:30 

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
Web01 | 2.8.140916.1 | Last Updated 18 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid