Add support for expression operator overloading #52

Closed
hisystems opened this Issue Apr 21, 2012 · 0 comments

Projects

None yet

1 participant

@hisystems
Owner

Support where appropriate operator overloading that allows creating expressions using standard arithmetic and string concatenation operators.

@hisystems hisystems was assigned Apr 24, 2012
@hisystems hisystems added a commit that closed this issue May 5, 2012
@hisystems Added support SQLExpression operator overloading. Closes #52.
Provides the powerful ability to generate SQL expressions for arithmetic operations and string concatenation using regular .NET code. Any arithmetic operator or string concatenation can be applied to an SQLExpression and the appropriate operator is translated into the appropriate SQL command. This significantly simplifies the .NET code and also simplifies the process of generating the SQL code, because normal .NET operators can be utilised.

For example: "New SQLFieldExpression("Field") Mod 10" translates to SQL "([Field] % 10)". The expression can be used in an SQLSelect, SQLInsert, SQLDelete or SQLUpdate class (amongst others).
606727d
@hisystems hisystems closed this in 606727d May 5, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment