Since 1-M lazy loading usually results in NHibernate issuing SQL queries with the foreign key to the 1 side of the relationship, is it a good practice to add a query to this column

e.g.

<many-to-one name="Order"
class="Emsi.Order.Data.DomainModel.Order, Emsi.Order.Data">
<column name="OrderId" index="OrderIndex" not-null="true"/>
</many-to-one>

Do you mean adding an index? It depends on the database, some add an index when you define a foreign key, some don't.

MS Sql Server, which I believe doesn't add it by default.

craig

Then it will usually help, but this is really a question outside NHibernate scope.

I agree. That is not an NHibernate concern.