Linq 中的动态 Where 查询如何实现 OR ？

[Triumph]

Info 表中有两个字段：N 和 V，都是字符串类型，现要查询：N 等于 n1 并且 V 包含 v1，或者N等于 n2 并且 V 包含 v2，或者 N 等于 n2 并且 V 包含 v3，写 linq 如下：

from t in info where (t.N = "n1" And t.V.Contains("v1")) Or (t.N = "n2" And t.V.Contains("v2")) Or (t.N = "n3" And t.V.Contains("v3"))

这个运行正确。

但实际上查询的关键字是动态的，数量是未知的，于是建立一个 Dictionary(Of String, String)：

Dim keyList As New Dictionary(Of String, String)
keyList.Add("n1","v1")
keyList.Add("n2","v2")
keyList.Add("n3","v3")
....
....

dim _q = From t In info
For Each key As String In keyList.Keys
dim _v As String = keyList(key)
_q = _q.Where(Function (x) x.N = key And x.V.Contains(_v))
Next

这样最终的查询条件就全都是 And 而不是前一个的OR b ，结果当然不正确。

请教各位如何这种情况如何实现？

[threenewbee]

_q = _q..Union(_q.Where(Function (x) 下一个条件))

[Triumph]

结果不正确呀？连单个的都查询不出来了

[romanchaos]

dim _q = From t In info Where 条件1 For Each key As String In keyList.Keys dim _v As String = keyList(key) _q = _q.Union(_q.Where(条件Next)) Next

[romanchaos]

修改一下 dim _q = From t In info dim _p = IQuaeryable<info> For Each key As String In keyList.Keys dim _v As String = keyList(key) _p = _p.Union(_q.Where(条件Next)) Next

[Triumph]

romanchaos：后一个管用，而且思路很好，让我豁然开朗。非常感谢！！！