Ivan, can you make a reproducable test? Best Regards, Alexander
On Wed, Nov 26, 2014 at 8:28 PM, Иван Иванов <[email protected]> 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. > -- 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.
