you can use: .SetMaxResults(1).UniqueResult<MyEntity> != null
It'll be true if a record was found. Diego On Wed, Dec 2, 2009 at 11:01, kor <[email protected]> wrote: > hi, i need to know if a select returns at least one result. > > the select with nhibernate is > > Session.CreateCriteria(typeof(MyEntity)) > .Add(Expression.Eq("Name", name)); > .List<MyEntity>(); > > I need to know if that select will return at least one result, the > table is very big so i don't use Count(***) > 0 > but i'm using the EXISTS function wich will break when the select get > the first result. > > currently i'm using directly a sql query (FIREBIRD) > > SELECT 1 FROM rdb$database WHERE EXISTS(SELECT * FROM MyEntityTable > WHERE NAME = :Name) > > wich will return 1 if the select will returns at least 1 result or no > data if no result exist. > > Can i get the same behaviour using icriteria (or hql if i can only > with it)? > > NOTE: i don't need to get the exact result of my sql query, for > example i can also get 0 if results count is 0, 1 otherwise, the > important thing is to use exists to sudden break when a matching > record is found. > > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > > -- 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.
