Searching and Linq

[Andy]

Hi,

I'm trying to update some custom code to linq. The issue I'm hitting
is this. The user can enter several keywords (no limit on how many),
and I'm searching a field in the database and I'd like to return
anything that has at least ONE of the keywords matching.

Any way to acomplish this with linq?

 

[Martin Honnen]

I'm trying to update some custom code to linq. The issue I'm hitting
is this. The user can enter several keywords (no limit on how many),
and I'm searching a field in the database and I'd like to return
anything that has at least ONE of the keywords matching.

Any way to acomplish this with linq?

Is that LINQ to SQL? It should translate a

List<string> keywords = new List<string>();
keywords.Add("foo");
keywords.Add("bar");

var query = from record in db.SomeTable
where keywords.Contains(record.field)
select record;

into a SQL field IN ('foo', 'bar').

 

[Andy]

I wanted to implement this in my project, but it was not going to be whatI
thought it would be and I abandon it.http://talentgrouplabs.com/blog/archive/2007/11/26/dynamic-linq-queri...

Maybe you can use the Split c# statement with it.

__________ Information from ESET NOD32 Antivirus, version of virus signature database 4037 (20090427) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com

Thanks! This helped me a great deal!