Click here to Skip to main content
15,921,716 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
GeneralRe: Voting Functionality -- Incoming Traffic Pin
Civic0619-Jan-11 23:30
Civic0619-Jan-11 23:30 
GeneralRe: Voting Functionality -- Incoming Traffic Pin
Ray Cassick20-Jan-11 8:45
Ray Cassick20-Jan-11 8:45 
QuestionAny good sofwtare design software? Pin
venomation12-Jan-11 15:03
venomation12-Jan-11 15:03 
AnswerRe: Any good sofwtare design software? Pin
Pete O'Hanlon12-Jan-11 21:25
mvePete O'Hanlon12-Jan-11 21:25 
AnswerRe: Any good sofwtare design software? Pin
David Skelly12-Jan-11 22:23
David Skelly12-Jan-11 22:23 
AnswerRe: Any good sofwtare design software? Pin
Stefan_Lang4-Feb-11 0:43
Stefan_Lang4-Feb-11 0:43 
QuestionNeed Design Ideas Pin
Kevin Marois12-Jan-11 10:41
professionalKevin Marois12-Jan-11 10:41 
AnswerRe: Need Design Ideas Pin
Pete O'Hanlon12-Jan-11 21:24
mvePete O'Hanlon12-Jan-11 21:24 
AnswerRe: Need Design Ideas Pin
GParkings2-Sep-11 2:40
GParkings2-Sep-11 2:40 
QuestionApplication design code samples Pin
Chesnokov Yuriy12-Jan-11 4:29
professionalChesnokov Yuriy12-Jan-11 4:29 
AnswerRe: Application design code samples Pin
Eddy Vluggen12-Jan-11 4:52
professionalEddy Vluggen12-Jan-11 4:52 
AnswerRe: Application design code samples Pin
Kevin Marois12-Jan-11 5:54
professionalKevin Marois12-Jan-11 5:54 
QuestionSCRUM Pin
Civic0610-Jan-11 9:44
Civic0610-Jan-11 9:44 
AnswerRe: SCRUM Pin
Praveen Raghuvanshi10-Jan-11 17:47
professionalPraveen Raghuvanshi10-Jan-11 17:47 
GeneralRe: SCRUM Pin
Civic0611-Jan-11 2:10
Civic0611-Jan-11 2:10 
GeneralRe: SCRUM Pin
Praveen Raghuvanshi11-Jan-11 18:54
professionalPraveen Raghuvanshi11-Jan-11 18:54 
GeneralRe: SCRUM Pin
Ravi Sant17-Jan-11 21:57
Ravi Sant17-Jan-11 21:57 
QuestionObject heuristic Pin
Leslie Sanford5-Jan-11 11:35
Leslie Sanford5-Jan-11 11:35 
AnswerRe: Object heuristic Pin
Luc Pattyn5-Jan-11 13:06
sitebuilderLuc Pattyn5-Jan-11 13:06 
GeneralRe: Object heuristic Pin
Leslie Sanford5-Jan-11 13:51
Leslie Sanford5-Jan-11 13:51 
GeneralRe: Object heuristic Pin
Luc Pattyn5-Jan-11 14:06
sitebuilderLuc Pattyn5-Jan-11 14:06 
AnswerRe: Object heuristic Pin
Paul Michalik7-Jan-11 1:24
Paul Michalik7-Jan-11 1:24 
QuestionDatabase Code Pin
Leslie Sanford5-Jan-11 5:46
Leslie Sanford5-Jan-11 5:46 
AnswerRe: Database Code Pin
dasblinkenlight12-Jan-11 11:42
dasblinkenlight12-Jan-11 11:42 
In my experience, when it comes to "combinatorial explosions", your projections (i.e. $columns) and ordering (i.e. $orderBy) are not as much a problem as the query conditions themselves: you will need to hard-code nearly as many values passed for the $where as the number of 'get<...>by<...>' functions you previously needed to code.
The solution I've been using is generating my 'where' clauses dynamically. This way, instead of pre-made 'where' clauses you'd build collections of uniform items from which your SQL can be generated. For example, a list of name-value pairs could be used to generate a conjunction like name1=value1 AND name2=value2 AND ... nameN=valueN. More advanced solutions include use of expression libraries, such as LINQ's Expression in .NET, to formulate composite queries of arbitrary complexity (with 'OR's, 'AND's, 'NOT's, and function calls).

P.S. Any time you generate SQL dynamically you should be very careful to avoid the SQL Injection Trap; other than that, you should be OK.
QuestionMatching between product and customer personal information Pin
Yanshof3-Jan-11 20:07
Yanshof3-Jan-11 20:07 

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.