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

Posted by ActionFactory on Stack Overflow See other posts from Stack Overflow or by ActionFactory
Published on 2010-01-22T13:46:55Z Indexed on 2010/03/25 8:03 UTC
Read the original article Hit count: 254

Filed under:

ADO.NET

|

like-operator

|

full-text-search

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

© Stack Overflow or respective owner

Related posts about ADO.NET

Asp.net ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
ADO.NET Entity Framework or ADO.NET

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm starting a new project based on ASP.NET and Windows server. The application is planned to be pretty big and serve large amount of clients pulling and updating high freq. changing data. I have previously created projects with Linq-To-Sql or with Ado.Net. My plan for this project is to use VS2010… >>> More
RIA Services vs ADO.NET Data Services

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently in the process of creating a Silverlight 3 data driven application. To access the database, 2 common approaches are used: RIA Services and ADO.NET Data Services. Does anyone have any guidance on when/why to choose each approach? Here is what I've gathered from my research / experience… >>> More
Ado.net dataservices BeginExecuteBatch call works on development fails on production server with Obj

as seen on Stack Overflow - Search for 'Stack Overflow'
We have an ado.net dataservices 1.0 call that is being passed to a [WebGet] service operation as a batch through BeginExecuteBatch. Everything works perfectly on our development server - we have the project configured to use IIS instead of the cassini web server to make it as close to our production… >>> More
ADO.Net : Get table definition from SQL server tables

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using C# to write a method that returns the following information about a table: column names, column types, column sizes, foreign keys. Can someone point me in the right direction on how to accomplish this ? >>> More

Related posts about like-operator

Why friend overloaded operator is preferred to conversion operator in this case

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a code like this, I think both the friend overloaded operator and conversion operator have the similar function. However, why does the friend overloaded operator is called in this case? What's the rules? Thanks so much! class A{ double i; public: A(int i):i(i) {} operator… >>> More
Operator overload for [] operator

as seen on Stack Overflow - Search for 'Stack Overflow'
Why would you need to overload the [] operator? I have never come across a practical scenario where this was necessary. Can somebody tell me a practical use case for this. >>> More
null-coalescing operator or conditional operator

as seen on Stack Overflow - Search for 'Stack Overflow'
Which coding style do you prefer: object o = new object(); //string s1 = o ?? "Tom"; // Cannot implicitly convert type 'object' to 'string' CS0266 string s3 = Convert.ToString(o ?? "Tom"); string s2 = (o != null) ? o.ToString() : "Tom"; s2 or s3? Is it possible to make it shorter? s1 does not… >>> More
c++ shorthand operator-> operator(_

as seen on Stack Overflow - Search for 'Stack Overflow'
Suppose I have Foo foo; is there a shorthand for foo.operator-().operator(1, 2) ? Thanks! >>> More
operator inside operator not working........

as seen on Stack Overflow - Search for 'Stack Overflow'
char b; operator<<(cout,(operator>>(cin,b))); this is not compiling in vc++ because all 8 overloads cant convert this type. can any one explain this..... is their a problem with return type........... >>> More