home | software | utility classes | c# sql filter class
An example usage, showing a simple case:
...will produce console output...
Note that the column names have been escaped appropriately for Sql Server and the ADO.NET
DataView.Filter property (as per my original requirement for this class).
Similarly, string values are properly quoted and escaped, and numeric types are handled correctly.
Supported conditional operators include:
Or are supported. Calling the conditional operator methods listed above
gives logical And behavior. Methods for logical Or behaviour are prefixed with
Or such as
Once you have a Filter class instance, you can use it in ADO.NET code, such as the creation of Sql commands
The Filter class maintains a tree structure of logical operators and conditional operators. Every time a
filtering method is called (
LessThan...) this tree has a new leaf or node added. Creating the
final expression involves traversing this tree. A hierarchy of internal types are included within the
Filter class to support this structure in a strongly-typed fashion.
Please feel free to provide feedback on this class . Bug reports are most appreciated when accompanied by a failing NUnit test case.