like linq sql
i have slight needs accept an array republic names, relapse list annals review those republic names. i'm perplexing this
public common duty getconcessions(byval countries string()) ienumerable
low countrylist twine = utility.joinarray(countries) ' turns twine array comma-separated string
relapse (from t new db().concessions _
where countrylist t.country _
name t.concessionid, t.title, t.country)
end function
but i error
*only arguments evaluated fan upheld method
in plain sql, simple:
name concessionid,title concessions c where @countrylist '%' + c.country + '%'
how i grasp outcome linq sql?
edit (clarification)
i same summary string.contains. glorious
t.country.contains(countrylist)
but i need
countrylist.contains(t.country)
and throws same blunder i listed above.
Comments
Post a Comment