Click here to Skip to main content
15,906,341 members
Home / Discussions / Design and Architecture
   

Design and Architecture

 
Questionimplementing effective searching in business code(maybe with linq?) Pin
giddy_guitarist5-Oct-08 7:35
giddy_guitarist5-Oct-08 7:35 
AnswerRe: implementing effective searching in business code(maybe with linq?) Pin
Pete O'Hanlon5-Oct-08 11:21
mvePete O'Hanlon5-Oct-08 11:21 
GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
giddy_guitarist5-Oct-08 17:37
giddy_guitarist5-Oct-08 17:37 
GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
Pete O'Hanlon5-Oct-08 22:07
mvePete O'Hanlon5-Oct-08 22:07 
GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
giddy_guitarist5-Oct-08 22:31
giddy_guitarist5-Oct-08 22:31 
AnswerRe: implementing effective searching in business code(maybe with linq?) Pin
Mark Churchill5-Oct-08 21:08
Mark Churchill5-Oct-08 21:08 
GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
giddy_guitarist5-Oct-08 22:45
giddy_guitarist5-Oct-08 22:45 
GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
Mark Churchill5-Oct-08 23:18
Mark Churchill5-Oct-08 23:18 
Roughly correct. A simple implementation would have say:

Expression { virtual ToString() }
ColumnEqExpression : Expression { column, value }
ColumnGtExpression : Expression { column, value }
OrExpression : Expression { Expression left, right }

So you could construct up (and some nicer static methods could make this more readable - see our API)
myExpr = new OrExpression( left = new ColumnEqExpression(name, joe), right = new ColumnGtExpression(age, 20) );

So the ColumnMatchExpression.ToString might* return "name = 'joe'"
OrExpression.ToString might* return left.ToString() + " OR " + right.ToString()

* The expression structure shouldn't actaully return out SQL with ToString. It should be treated as a model - so have an SQLQueryDielectThingo to iterate over it and emit SQL (so you could write an AccessQueryDielect, etc). Also then you would be able to use parameterised queries where appropriate.


GeneralRe: implementing effective searching in business code(maybe with linq?) Pin
giddy_guitarist9-Oct-08 20:40
giddy_guitarist9-Oct-08 20:40 
QuestionDistributed Computing Special Pin
abhigad2-Oct-08 19:50
abhigad2-Oct-08 19:50 
QuestionXSS-CGI-RFI-SQL Injection Scanner Project Help Pin
Fuat Mx1-Oct-08 22:25
Fuat Mx1-Oct-08 22:25 
AnswerRe: XSS-CGI-RFI-SQL Injection Scanner Project Help Pin
ozguryasarakyar26-Dec-09 12:24
ozguryasarakyar26-Dec-09 12:24 
GeneralRe: XSS-CGI-RFI-SQL Injection Scanner Project Help Pin
Fuat Mx26-Dec-09 21:27
Fuat Mx26-Dec-09 21:27 
QuestionIntegrating scripting languages with "low-level" languages. Pin
Leslie Sanford1-Oct-08 19:45
Leslie Sanford1-Oct-08 19:45 
AnswerRe: Integrating scripting languages with "low-level" languages. Pin
led mike2-Oct-08 5:27
led mike2-Oct-08 5:27 
QuestionImplementing Model View Presenter Pin
Giorgi Dalakishvili30-Sep-08 22:18
mentorGiorgi Dalakishvili30-Sep-08 22:18 
AnswerRe: Implementing Model View Presenter Pin
stavinski1-Oct-08 3:29
stavinski1-Oct-08 3:29 
GeneralRe: Implementing Model View Presenter Pin
Giorgi Dalakishvili2-Oct-08 22:41
mentorGiorgi Dalakishvili2-Oct-08 22:41 
QuestionDesign solution for .NET application. Pin
xbuster28-Sep-08 3:11
xbuster28-Sep-08 3:11 
Questioncreating a _simple_ fine grained user based security system Pin
giddy_guitarist27-Sep-08 6:37
giddy_guitarist27-Sep-08 6:37 
AnswerRe: creating a _simple_ fine grained user based security system Pin
Pete O'Hanlon27-Sep-08 8:54
mvePete O'Hanlon27-Sep-08 8:54 
GeneralRe: creating a _simple_ fine grained user based security system Pin
giddy_guitarist27-Sep-08 20:22
giddy_guitarist27-Sep-08 20:22 
GeneralRe: creating a _simple_ fine grained user based security system Pin
Pete O'Hanlon28-Sep-08 9:21
mvePete O'Hanlon28-Sep-08 9:21 
GeneralRe: creating a _simple_ fine grained user based security system Pin
giddy_guitarist5-Oct-08 7:39
giddy_guitarist5-Oct-08 7:39 
QuestionCreating 3-Tier system, technology to use. Pin
RDoes26-Sep-08 1:06
RDoes26-Sep-08 1:06 

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.