How to Filter ADO.NET data using a Full Text Seach (FTS) field?

Question

Hi All, We are using ADO.NET dataservices & are building URL based filters. Example: /Customers?filter=City eq 'London'

We now need to filter on a Full Text 'tags' Field. WAS HOPING FOR: /Customers?filter=Tag like 'Friendly'

PROBLEM: ADO.NET does not have a LIKE operator. ADO.NET does not seem to like FTS (It is not finding a match - because it is not parsing through the CSV's)

Any ideas how to make this work? THX

Answer 1

I haven't worked with ADO.NET Data Services per se, but, when working with Full Text Search, I have found that the CONTAINS operator is much more powerful. Whether in an ad hoc sql string, or in a stored proc.