I have a feeling, don't know why, but I think that Alexander Zaytsev is the
one you should talk to...
;-)
RP
On Wednesday, November 26, 2014 7:28:06 AM UTC, Иван Иванов wrote:
>
> NHibernate 4.0.2.GA
>
> Query:
>
> var list = session
> .Query<City>()
> .Cacheable()
> .CacheMode(CacheMode.Normal)
> .Where(x => x.Name.Contains("New"))
> .Take(1)
> .ToList();
>
> Result:
> Cached query:
> select TOP ('New' /* @p0 */) city0_.CITY_ID as CITY1_3_,
> city0_.URL as URL3_,
> city0_.NAME as NAME3_,
> from CITY city0_
> where city0_.NAME like ('%' + 1 /* @p1 */ + '%')
>
> any ideas how to fix????
>
> суббота, 22 ноября 2014 г., 19:10:06 UTC+5 пользователь Иван Иванов
> написал:
>>
>> Hi
>>
>> My query:
>>
>> query
>> .Where(x => x.Name.Contains(value))
>> .Take(25)
>> .ToList();
>>
>> English:
>> Cached query:
>> select TOP (25 /* @p0 */) city0_.CITY_ID as CITY1_3_,
>> city0_.URL as URL3_,
>> city0_.NAME as NAME3_
>> from CITY city0_
>> where city0_.NAME like ('%' + 'New' /* @p1 */ + '%')
>>
>> Russian:
>> select TOP ('Моск' /* @p0 */) city0_.CITY_ID as CITY1_3_,
>> city0_.URL as URL3_,
>> city0_.NAME as NAME3_
>> from CITY city0_
>> where city0_.NAME like ('%' + 25 /* @p1 */ + '%')
>>
>> bug?
>>
>>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
