We are reviewing the capabilities of OpenAccessLinqDataSource
, in particular its filtering functionality.
Having read this page
we want to learn how flexible the filter expressions could be.
1) Is it possible to set up filtering with LIKE predicate? Something like:
<entity_property> contains @text_param
For example, in Oracle SQL we could use:
tableA.columnB LIKE '%'|| :text_param ||'%'
What is the syntax in OpenAccessLinqDataSource
2) Which properties/events can be pulled in to change filter expressions in run time?