I'm trying to figure out the right way to find text in my database. I have a column named "Description" and thought it would be nice to use the ParameterBuilder to construct it (rather than writing T-SQL). So I tried this:
MyTableParameterBuilder query = new MyTableParameterBuilder();
query.Append(MyTableColumn.Description, "%search term%", true); // ignore case
Find(query);
However this doesn't seem to work so I had to use:
Find("Description LIKE %search term%");
Am I using the parameter builder classes incorrectly or are they only for locating column values directly and not for text searches?