如何使用动态LINQ(System.Linq.Dynamic)进行LIKE操作? [英] How to use Dynamic LINQ (System.Linq.Dynamic) for LIKE operation?

问题描述

任何人都可以告诉我如何使用 System.Linq.Dynamic ?

Can any body tell me how can I use a LIKE operator using System.Linq.Dynamic?

我需要在动态 where查询中添加多个LIKE表达式

I need to add more than one LIKE expression in my dynamic where query

/*
var query =
db.Customers.
Where("CityName Like @0 or CityName Like @1", "London", "USA")
*/
var query =
db.Customers.
Where("CityName Like @0 or CityName Like @1%", "London", "USA")

感谢堆

推荐答案

尝试简单地使用"CityName.Contains(@ 1)"，由于它将对可访问类型进行方法调用，因此它将转换为适当的lambda.

Try using simply "CityName.Contains(@1)" this will convert to the proper lambda since its a method invocation on an accessible type.

类似:

var query =
db.Customers.
Where("CityName.Contains(@0) or CityName.Contains(@1)", "London", "USA")

只需使用动态库随附的示例应用程序对其进行测试，它就会生成LIKE运算符

Just tested it with the sample app that comes with the dynamic library and it generates the LIKE operator

这篇关于如何使用动态LINQ(System.Linq.Dynamic)进行LIKE操作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！