[nhusers] Why doesn't nHibernate batch to the database on this query.

[Steve Lyle]

I profile the SQL server and don't see any attempt to hit the server from 
Hibernate.
Also no errors thrown.
The only thing that happens is Hibernate returns an empty row set.

The query:
            var cfg = new Configuration();
            cfg.Configure();
            ISessionFactory sesFactory = cfg.BuildSessionFactory();
            var ses = sesFactory.OpenSession();
            var qry = ses.CreateQuery("from 
Tko.SmartMoves.Modules.Operations.Domain.vDoors");
            IList<vDoors> x = qry.List<vDoors>();
If I set the same thing up using ICriteria I have the same problem.


But this works ~ all other things being equal:
            string sql = string.Format("select * from vDoors");
            var cfg = new Configuration();
            cfg.Configure();
            ISessionFactory sesFactory = cfg.BuildSessionFactory();
            var ses = sesFactory.OpenSession();
            var qry = ses.CreateSQLQuery(sql);
            IList<vDoors> x = qry.List<vDoors>();

Thanks.

-- 
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 nhusers+unsubscr...@googlegroups.com.
To post to this group, send email to nhusers@googlegroups.com.
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.