Can OA\Linq query for multiple IDs?

[sitefinitysteve]

If I have a List<int> of product IDs, can OA somehow just return me back those items instead if me having to loop through?  Is there like a .Contains that i can use?  Or do I have to manually get the items one at a time and add them to a local collection?

[IT-Als]

Hi Steve,

You can use the generic version of QueryResult<int> and then use the ToList() method on the result instance... it will hand you a (generic) list of int.
Does it solve your problem?

/Henrik

[sitefinitysteve]

Hey there Henrik,
  You know I posted this REALLY late, and reading it back now, it makes no sense :)

The productID list would store (for example) product IDs 1, 5, 8.

So how would I query my model to get those 3 in a single query instead of having to call out three times to build me own list

Sorry about the confusion :)
Steve

[IT-Als]

Hi Steve,

That's ok - been working late, too, lately so I know the feeling.

Anyway, I am not aware of any query construct that can hand you what you need besides the ToList() method. Those product ids, do you collect them from the same entity?
Can you show me in OQL/LINQ/SQL what you are trying to achive and how you select those product id values and from where..

Regards
Henrik

[Damyan Bogoev]

Hi Steve,

You can use the following query to achieve this:

...
List<int> productIdList = new List<int> { 1, 5, 8 };
IQueryable<Product> filteredProducts = context.Products.Where(p => productIdList.Contains(p.ProductID));
...

Hope that helps.

Greetings,
Damyan Bogoev
the Telerik team

[IT-Als]

Of cause, Damyan...

Thanks for adding this snippet to the knowledge bank in my brain :-)

/Henrik