Linq query using like on client side

[sqlguy]

I have tried to use the SqlMethod.Like in a client side query but it will not work (only on Server side)..

Is there any way to use a like on the client side.

Does not work:

Dim items = (From xm In xmlFile.sms Where SqlMethods.Like(xm.body, value) Select ToFrom = DecodeType(xm.type), xm.readable_date, theDate = DateTime.Parse(xm.readable_date), xm.body).ToList

Works but not a like:

Dim items = (From xm In xmlFile.sms Where xm.body.Contains(value) Select ToFrom = DecodeType(xm.type), xm.readable_date, theDate = DateTime.Parse(xm.readable_date), xm.body).ToList




Lloyd Sheen

Continue reading...