LINQ条件查询语句.解决思路
LINQ条件查询语句.VB codeDim a As String someVlaueDim b As String someVlaueDim sql As String
LINQ条件查询语句.
VB code Dim a As String = someVlaue Dim b As String = someVlaue Dim sql As String = "select * from table1 where column1 = 1"If a <> "" Thensql = sql + " and columnA = '" + a + "'"End IfIf b <> "" Thensql = sql + " and columnB = '" + b + "'" End If
请问如何将以上代码转换为LINQ。 最好用VB.NET。 谢谢！
[解决办法]参考
[解决办法]var v=able1.Where(a=>a.column1==1);
没看到if，简单的做法
If a <> "" Then
v.Where(a=>a. columnA =="a");
End If
If b <> "" Then
v.Where(a=>a. columnB =="b");
End If
