Hibernate version:1.2.
Name and version of the database you are using: Oracle 10

Hi,

I have a performance problem, I have to increase performance of my project.
I need to read 100.000 records from a db table.
If I use ado.net with a datareader I can create a cursor with only one query.
But query.Enumerable<MyClass>() executes a first query to retrieve all primary keys then it executes a query for each record.
Is it possible to configure nhibernate to use only one query like ado.net?

Thank you and sorry for my bad english

Michele Fabbri