Is it possible to work with the two dialects in one session factory and to choose the appropriate to query(session)? As I understand it is not possible. Maybe there are some workarouds other than using sql native queries (named)?
On 31 янв, 04:00, Ayende Rahien <[email protected]> wrote: > Use the Sql 2000 dialect > > > > On Fri, Jan 30, 2009 at 4:39 PM, letov <[email protected]> wrote: > > > My sample code: > > > var freeTicket1 = (from ticket in Session.Linq<Ticket>() > > where ticket.IsFree select ticket).FirstOrDefault(); > > var freeTicket2 = (Ticket)Session.CreateQuery("from Ticket > > ticket where ticket.IsFree=1").SetMaxResults(1).UniqueResult(); > > var freeTicket3 = (Ticket)Session.CreateCriteria(typeof > > (Ticket)).Add(Restrictions.Eq("IsFree", true)).SetMaxResults > > (1).UniqueResult(); > > return freeTicket1 ?? freeTicket2 ?? freeTicket3; > > > SQL for all queries: > > > SELECT TOP 1 PK1_2_0_, > > DT2_2_0_, > > BLN3_2_0_ > > FROM > > ( > > SELECT ROW_NUMBER ( ) OVER ( ORDER BY > > __hibernate_sort_expr_0__ ) as > > row, > > query.PK1_2_0_, > > query.DT2_2_0_, > > query.BLN3_2_0_, > > query.__hibernate_sort_expr_0__ > > FROM > > ( > > SELECT this_.PK_TICKET as PK1_2_0_, > > this_.DT_CAPTURE as DT2_2_0_, > > this_.BLN_FREE as BLN3_2_0_, > > CURRENT_TIMESTAMP as > > __hibernate_sort_expr_0__ > > FROM COMMON.TBL_TICKET this_ > > WHERE this_.BLN_FREE = 1 /* @p0 */ > > ) query > > ) page > > WHERE page.row > 0 > > ORDER BY __hibernate_sort_expr_0__ > > > On 30 янв, 23:35, Tuna Toksoz <[email protected]> wrote: > > > .SetMaxResult() ? > > > > Tuna Toksözhttp://tunatoksoz.comhttp://twitter.com/tehlike > > > > Typos included to enhance the readers attention! > > > > On Fri, Jan 30, 2009 at 10:22 PM, letov <[email protected]> wrote: > > > > > Hello everyone. > > > > Is there a way to get pure "SELECT TOP" on sql server 2005, using hql > > > > or criteria api or nhibernate.linq? > > > > Thanks.- Скрыть цитируемый текст - > > > > - Показать цитируемый текст -- Скрыть цитируемый текст - > > - Показать цитируемый текст - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
