How to use Dynamic LINQ (System.Linq.Dynamic) for LIKE operation?

c# asp.net linq dynamic-linq
Kiarash picture Kiarash · Jan 5, 2011 · Viewed 16.3k times · Source

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

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")

thanks heaps

Answer

Jaime picture Jaime · Jan 5, 2011

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

something like:

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

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

Related questions

Sequence contains more than one element

I'm having some issues with grabbing a list of type "RhsTruck" through Linq and getting them to display. RhsTruck just has properites Make, Model, Serial etc... RhsCustomer has properties CustomerName, CustomerAddress, etc... I keep getting the error "Sequence contains more …

Read More
Cannot convert lambda expression to type 'string' because it is not a delegate type

I am using a LINQ lambda expression like so: int Value = 1; qryContent objContentLine; using (Entities db = new Entities()) { objContentLine = (from q in db.qryContents where q.LineID == Value orderby q.RowID descending select q).FirstOrDefault(); } However, I am getting the …

Read More
How to convert DataTable to class Object?

I have already developed an application which returns DataTable everywhere. Now my client wants to convert (use some part using service stack), so I need to return DTO (objects) in my application. I don't want to change my existing stored …

Read More