I got one big question.
I got a linq query to put it simply looks like this:
from xx in table
spoulson has it nearly right, but you need to create a
string first. Actually a
List<int> would be better if uid is also
uid.ToString().Contains(string) would imply that the uid as a string contains all of the values of the array as a substring??? Even if you did write the extension method the sense of it would be wrong.
Unless you changed it around and wrote it for
string as Mitch Wheat demonstrates, then you'd just be able to skip the conversion step.
Here is what you want, if you don't do the extension method (unless you already have the collection of potential uids as ints -- then just use
List<int>() instead). This uses the chained method syntax, which I think is cleaner, and
does the conversion to int to ensure that the query can be used with more providers.
var uids = arrayofuids.Select(id => int.Parse(id)).ToList(); var selected = table.Where(t => uids.Contains(t.uid));