Linq to Sql Criteria in String Array

Question

I have say three tables.

Projects

Id
Name

Categories

Id
Name

ProjectCategories

Id
ProjectId
CategoryId

I now have an array of strings which represents categories the user has elected to search on. I now need to find all the projects that have those category attached to them.

I tried;

string[] searchTerms = new string[2];
searchTerms[0] = "paint";
searchTerms[1] = "painting";

IQueryable<Project> projects = (from category in dc.ProjectCategories
where searchTerms.Any(val => category.Category.Name.Contains(val))
select category.Project).Distinct();

But I get the error;

{"Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator."}

tvanfosson · Accepted Answer · 2009-12-02 21:11:05Z

1

Unless I'm mistaking your meaning, which is possible, I think you can just do a contains with the searchTerms

where searchTerms.Contains( category.Category.Name )

this will translate into SQL as

... WHERE Name IN ('paint','painting') ...

answered Dec 2, 2009 at 21:11

tvanfosson

534k102 gold badges703 silver badges801 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

griegs Over a year ago

Argh! So easy when you see it. Thanks @tv.

Collectives™ on Stack Overflow

Linq to Sql Criteria in String Array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related