Dynamic Linq return wrong result

Question

I want to search address by linq, I use in 2 ways:

Linq:

_db.Address.Where(address => address.FullName.Contains(text));

Dynamic Linq:

_db.Address.Where("FullName.Contains(@0)", text);

When I try:

-> text value is string (doesnot contain space), the result in 2 querys is the same,

-> text value is number or string with space inside, the query 1 return right result, and the second one return null

I don't have Sql Profiler, so I cannot check the general sql.

How to fix this issus and how to work with dynamic linq in right way?

www.linqpad.net will connect to you db and create a context. Then from there you can see generate queries. — Cubicle.Jockey, May 29 '14 at 05:00
@Cubicle.Jockey: Please help me make it works with Linq.Dynamic? — Stiger, May 29 '14 at 05:25
can you provide sample input and output data, and also expected output? — Grundy, Jun 09 '14 at 07:41

score 2 · Answer 1 · answered May 29 '14 at 04:58

2

I think you need to do this way:

_db.Address.Where("FullName like @0", text);

or you can do like this as well:

_db.Address.Where(a => SqlMethods.Like(a.FullName, "%"+text+"%"))

answered May 29 '14 at 04:58

Ehsan Sajjad

The first way return me this error: `Expression of type 'Boolean' expected`. I want to search dynamic (not only `FullName` property), so the second way maybe not a good approach. – Stiger May 29 '14 at 05:09

1 Answers1