Hi,

I'm trying return all data from MS SQL 2000 table. I'm using below code:

public List<T> GetAll() {
return GetByCriteria();
}

public List<T> GetByCriteria(params ICriterion[] criterion) {
ICriteria criteria = session.CreateCriteria(persitentType);

foreach (ICriterion criterium in criterion) {
criteria.Add(criterium);
}

return ConvertToGenericList(criteria.List());
}

Everthing works ok but in query profiler I see that NHibernate makes query for each entity, so if table contains 2000 records NHibernate run 2000 query.
Is is possible to optimalize this search proces.

Thanks.

Could it be that NHibernate is querying additional data after having executed the first query for the criteria.List(), e.g. to populate a non-lazy many-to-one relationship? Could you give an example of your mapping and generated SQL?

Yes it was non-lazy many-to one relationship issue. I modified my mapping to
<bag name="FWXIndLocations" inverse="true" fetch="join">
<key column="IndividualID" />
<one-to-many class="FSI.Core.Domain.FWXIndLocation, FSI.Core" />
</bag>

I added fetch="join".

Thanks.