<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="Mehan.Navand.EntityLayer" assembly="Mehan.Navand.EntityLayer">
   <class name="ContactEntity" table="OrmContacts_ContactsTable" batch-size="25">
      <id name="Id" type="string" unsaved-value="null">
         <generator class="uuid.hex" />
      </id>
      <version name="Version" unsaved-value="-1"/>
      <property name="CreationDate" type="datetime"/>
      <property name="Confirmed"/>
      <property name="BankName" />
      <property name="BankAccount" />
      <property name="BankCardNumber" />
      <property name="Birthday" type="datetime" />
      <property name="BusinessAddress" />
      <property name="BusinessAddressCity" />
      <property name="BusinessAddressProvience" />
      <property name="BusinessAddressCountry" />
      <property name="BusinessAddressStreet" />
      <property name="BusinessEmail" />
      <property name="BusinessFax" />
      <property name="BusinessName" />
      <property name="BusinessOrganization" />
      <property name="BusinessPhone" />
      <property name="BusinessRole" />
      <property name="BusinessUrl" />
      <property name="BusinessWeblog" />
      <property name="CellNumber" />
      <property name="ForeName" />
      <property name="GoogleId" />
      <property name="HomeAddress" />
      <property name="HomeAddressStreet" />
      <property name="HomeAddressCity" />
      <property name="HomeAddressProvience" />
      <property name="HomeAddressCountry" />
      <property name="HomeFax" />
      <property name="HomePhone" />
      <property name="IcqId" />
      <property name="LastName" />
      <property name="MarriageDate" type="datetime" />
      <property name="Memo" />
      <property name="NickName" />
      <property name="PersonalEmail" />
      <property name="PersonalUrl" />
      <property name="PersonalWeblog" />
      <property name="Title" />
      <property name="YahooId" />
      <property name="Gender" />
      <set name="Properties" cascade="all-delete-orphan" lazy="true">
         <key column="Contact"/>
         <one-to-many class="ContactPropertyEntity"/>
      </set>
      <bag name="Labels" lazy="true" table="OrmContacts_ContactLabelsTable">
         <key column="ContactId"/>
         <element type="string" column="Label"/>
      </bag>
      <many-to-one cascade="none" name="Owner" column="OwnerId" class="MemberEntity" />
   </class>
</hibernate-mapping>

public IEnumerable<ContactEntity> GetContacts(string user, int startRowIndex, int maximumRows)
{
    string query="FROM ContactEntity AS ContactEntity WHERE Contact.Owner=?";

    IQuery iQuery = DatabaseManager.CurrentSession.CreateQuery(query);
    iQuery = iQuery.SetFirstResult(startRowIndex);
    iQuery = iQuery.SetMaxResults(maximumRows);
    iQuery = iQuery.SetParameter(0, user, NHibernateUtil.String);

    IEnumerable enumerable = iQuery.Enumerable();
    try {
       foreach (ContactEntity item in enumerable)
          yield return item;
    } finally {
        ((IDisposable)enumerable).Dispose();
    }
}

foreach(ContactEntity item in GetContacts("user",0,10)){
    Response.Write(item.Name+"<br/>");
}