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

Design and Architecture

 
GeneralRe: What tools do you use to design? Pin
bleedingfingers12-Oct-10 21:16
bleedingfingers12-Oct-10 21:16 
QuestionWhat kind of Methodology more suitable? Pin
Nasri879-Aug-10 2:55
Nasri879-Aug-10 2:55 
AnswerRe: What kind of Methodology more suitable? Pin
Richard MacCutchan9-Aug-10 22:26
mveRichard MacCutchan9-Aug-10 22:26 
QuestionImplementation MVC of problem Pin
fell02068-Aug-10 15:55
fell02068-Aug-10 15:55 
AnswerRe: Implementation MVC of problem Pin
R. Giskard Reventlov9-Aug-10 3:03
R. Giskard Reventlov9-Aug-10 3:03 
QuestionBank Transfer Pin
Gjm6-Aug-10 3:34
Gjm6-Aug-10 3:34 
QuestionDynamically filling dropdown values or manually Pin
anjelone24-Aug-10 16:03
anjelone24-Aug-10 16:03 
AnswerRe: Dynamically filling dropdown values or manually Pin
Pete O'Hanlon4-Aug-10 22:11
mvePete O'Hanlon4-Aug-10 22:11 
anjelone2 wrote:
First question, I'm curious what your typical projects look like in regards to this issue. Are the dropdown values manually listed out and what do you think of that method?


No. Just because you can manually add the items doesn't mean you should. What happens if you want to offer localised versions or you want to add a new item or remove one?


anjelone2 wrote:
Second question (and the biggest source of disagreement on our team), when you do move the values out to separate tables, do you continue to store the string values in the original database tables and join to the 'list manager' tables on that string, or do you create IDs on the 'list manager' tables and do a bunch of JOINs on the IDs between the original tables and the new tables?


Why is this even being debated. Have they never heard of database normalisation? Look at the space that's being wasted in a table storing the string values for every row - store the id of the item from the lookup table and do a join instead. It's only a few extra characters. BTW - one objection I sometimes hear is that you can't delete a lookup item in future because this breaks referential integrity, and this is true - you should never delete a lookup that has been used. What you can do though is add a Deleted column which indicates whether or not the item has been deleted.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.


My blog | My articles | MoXAML PowerToys | Onyx



GeneralRe: Dynamically filling dropdown values or manually Pin
anjelone25-Aug-10 9:07
anjelone25-Aug-10 9:07 
GeneralRe: Dynamically filling dropdown values or manually Pin
Pete O'Hanlon5-Aug-10 12:07
mvePete O'Hanlon5-Aug-10 12:07 
GeneralRe: Dynamically filling dropdown values or manually Pin
Eddy Vluggen6-Aug-10 4:29
professionalEddy Vluggen6-Aug-10 4:29 
GeneralRe: Dynamically filling dropdown values or manually Pin
Keith Barrow25-Sep-10 0:20
professionalKeith Barrow25-Sep-10 0:20 
GeneralRe: Dynamically filling dropdown values or manually Pin
PIEBALDconsult24-Sep-10 21:57
mvePIEBALDconsult24-Sep-10 21:57 
QuestionEnterprise Applications Pin
Ali el2-Aug-10 1:34
Ali el2-Aug-10 1:34 
AnswerRe: Enterprise Applications Pin
Pete O'Hanlon2-Aug-10 2:11
mvePete O'Hanlon2-Aug-10 2:11 
Questionhow to comprehend the definition of Bridge pattern by Gof? Pin
zxjun8422-Jul-10 18:56
zxjun8422-Jul-10 18:56 
QuestionSimple UML Question Pin
Nadunwow29-Jun-10 8:18
Nadunwow29-Jun-10 8:18 
AnswerRe: Simple UML Question Pin
Richard MacCutchan29-Jun-10 9:17
mveRichard MacCutchan29-Jun-10 9:17 
GeneralRe: Simple UML Question Pin
Nadunwow2-Jul-10 7:11
Nadunwow2-Jul-10 7:11 
AnswerRe: Simple UML Question Pin
Sameerkumar Namdeo16-Aug-10 0:10
Sameerkumar Namdeo16-Aug-10 0:10 
QuestionBuilding troubleshooting application Pin
sumit703428-Jun-10 20:53
sumit703428-Jun-10 20:53 
AnswerRe: Building troubleshooting application Pin
Mycroft Holmes23-Jul-10 14:07
professionalMycroft Holmes23-Jul-10 14:07 
QuestionData Modeling Tools Pin
Brendan Vogt17-Jun-10 3:13
Brendan Vogt17-Jun-10 3:13 
AnswerRe: Data Modeling Tools Pin
Pete O'Hanlon17-Jun-10 4:47
mvePete O'Hanlon17-Jun-10 4:47 
AnswerRe: Data Modeling Tools Pin
muthoot26-Jul-10 1:42
muthoot26-Jul-10 1:42 

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.