IQueryable

avidan · September 25th, 2015, 10:59 AM

I have the following code
Dim users As IQueryable(Of view_user)
dim country as string

country= "USA"

users = From r In myentities.view_user Where r.country = country Select r

This works perfect. The problem is, that there may be more than one country (from 1 to n). How can I code this for n countries? the result should be

users = From r In myentities.view_user Where r.country = country or r.country=country2 and r.country=country3 .... r.country= countryn Select r

Thanks.
Alexander Avidan

mmorgan30 · January 29th, 2017, 09:10 PM

see if the country is in a collection of valid countries

Code:

Dim validCountries() as string = GetValidCountries()


Dim userQuery = From r In myentities.view
               Where validCountries.Contains(r.country)
               Select r


Dim result = userQuery.ToArray()