fluent-query-builder icon indicating copy to clipboard operation
fluent-query-builder copied to clipboard

WhereBuilder for CONTAINS predicate

Open mguinness opened this issue 7 years ago • 1 comments

Firstly thanks for the great library, it's much simpler than using the native StringBuilder.

Do you think it's possible to adapt the library to help build the search condition for the CONTAINS predicate? For example:

WHERE CONTAINS(Description, '(Aluminum AND spindle) OR (Steel AND cutters)')

I see there is a constructor for WhereBuilder, although no default constructor.

public WhereBuilder(SelectBuilder selectBuilder, StringBuilder builder);

Can a WhereBuilder instance be used to create the example above, just using And, AndIf, Or, OrIf?

mguinness avatar Jan 26 '18 01:01 mguinness

Hi, @mguinness!

First, I'm happy that you're enjoying our lib!

I'm trying to figure it out how to put this in the API so that it makes sense. Could you provide us some usage sample of what are you thinking?

paulohenriquesi avatar Jan 26 '18 13:01 paulohenriquesi