2.0

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<joined-subclass extends="CMS.Domain.Content,CMS.Domain" name="CMS.Domain.File,CMS.Domain" table="`Files`" lazy="true">
<key column="`ID`" />

<property name="ContentType" column="`ContentType`" type="System.String" not-null="true" />
<property name="ContentLength" column="`ContentLength`" type="System.Int32" not-null="true" />
<property name="ContentExtension" column="`ContentExtension`" type="System.String" not-null="true" />
<property name="FileName" column="`FileName`" type="System.String" not-null="true" />
<property name="Data" column="`Data`" type="BinaryBlob" not-null="true" />
<one-to-one name="Content" cascade="save-update" />
</joined-subclass>
</hibernate-mapping>


Sql Server 2005


I'm attempting to get lazy loading working for a single property in my File class. The property is an image field in the database and it's been killing my performance. I've looked everywhere I could think of and cannot find an example of how to do this properly. If anyone could point me to an article or just show me how I would really appreciate it.

What about putting the BLOB data in a separate class and joining it with a one-to-one to the main object. Then you can use hibernates lazy loading mechanism.

Not that this helps you now, but it looks as though 2.1 will support property lazy-loading. The mapping xsd now includes lazy on the property. I've seen alot of stub code around it in the trunk as well.

If you have really large images in your database you may want to check this out: http://forum.hibernate.org/viewtopic.php?t=995551