Writing.
On Oct 20, 3:25 pm, "Fabio Maulo" <[EMAIL PROTECTED]> wrote:
> Only for a curiosity.Do you are writing the mapping or you are using some
> generator ?
>
> 2008/10/20 joe <[EMAIL PROTECTED]>
>
>
>
>
>
> > Thanks for helping.
>
> > I have a table Customer and a table State.
> > Each customer has an optional FKStateId.
> > My Customer class has a field of type State.
>
> > Here are the 2 mappings file:
>
> > CUSTOMER MAPPING:
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> > assembly="Syple.Velocity.Data" namespace="Syple.Velocity.Data.Domain">
> > <class name="Customer" table="customer">
> > <id name="ID" type="int" column="PKCustomerId">
> > <generator class="identity"/>
> > </id>
> > <property name="FirstName" column="FirstName" type="System.String"
> > not-null="false" />
> > <property name="MiddleName" column="MiddleName"
> > type="System.String" not-null="false" />
> > <property name="LastName" column="LastName" type="System.String"
> > not-null="false" />
> > <property name="Title" column="Title" type="System.String" not-
> > null="false" />
> > <property name="BusinessPhone" column="BusinessPhone"
> > type="System.String" not-null="false" />
> > <property name="HomePhone" column="HomePhone" type="System.String"
> > not-null="false" />
> > <property name="MobilePhone" column="MobilePhone"
> > type="System.String" not-null="false" />
> > <property name="EmailAddress" column="EmailAddress"
> > type="System.String" not-null="false" />
> > <property name="UnitNumber" column="UnitNumber"
> > type="System.String" not-null="false" />
> > <property name="StreetNumber" column="StreetNumber"
> > type="System.String" not-null="false" />
> > <property name="StreetName" column="StreetName"
> > type="System.String" not-null="false" />
> > <property name="Suburb" column="Suburb" type="System.String" not-
> > null="false" />
> > <property name="Postcode" column="Postcode" type="System.String"
> > not-null="false" />
> > <property name="CurrentVehicle" column="CurrentVehicle"
> > type="System.String" not-null="false" />
> > <property name="ReceiveMarketing" column="ReceiveMarketing"
> > type="System.Boolean" not-null="true" />
> > <property name="IsCompany" column="IsCompany"
> > type="System.Boolean" not-null="true" />
> > <many-to-one name="State" column="FKStateId" class="State" />
>
> > <one-to-one name="BusinessCustomer" class="BusinessCustomer"
> > cascade="all-delete-orphan" />
>
> > <bag name="Enquiries" table="enquiry" inverse="true" lazy="true"
> > cascade="save-update">
> > <key column="FKCustomerId" />
> > <one-to-many class="Enquiry"/>
> > </bag>
> > <bag name="SalesActivities" table="salesactivity" inverse="true"
> > lazy="true" >
> > <key column="FKCustomerId" />
> > <one-to-many class="SalesActivity"/>
> > </bag>
> > <bag name="Notes" table="customernote" inverse="true" lazy="true"
>
> > <key column="FKCustomerId" />
> > <one-to-many class="CustomerNote"/>
> > </bag>
> > </class>
> > </hibernate-mapping>
>
> > STATE MAPPING:
> > <?xml version="1.0" encoding="utf-8" ?>
> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> > assembly="Syple.Velocity.Data" namespace="Syple.Velocity.Data.Domain">
> > <class name="State" table="state" >
> > <id name="ID" type="int" column="PKStateId">
> > <generator class="assigned"/>
> > </id>
> > <property name="StateName" column="StateName"
> > type="System.String" not-null="true" />
> > <bag name="Customers" table="customer" inverse="true"
> > lazy="true" >
> > <key column="FKStateId" />
> > <one-to-many class="Customer"/>
> > </bag>
> > <bag name="BusinessCustomers" table="businesscustomer"
> > inverse="true" lazy="true" >
> > <key column="FKStateId" />
> > <one-to-many class="BusinessCustomer"/>
> > </bag>
> > </class>
> > </hibernate-mapping>
>
> > On Oct 20, 9:13 am, "Will Shaver" <[EMAIL PROTECTED]> wrote:
> > > Perhaps a bit more of the data model / mappings would be helpful here...
>
> > > On Sun, Oct 19, 2008 at 3:09 PM, joe <[EMAIL PROTECTED]> wrote:
>
> > > > Same result.
>
> > > > On Oct 18, 2:03 am, "Will Shaver" <[EMAIL PROTECTED]> wrote:
> > > >> Try .SetFetchMode(relation, FetchMode.Join);
> > > >> instead of Eager.
>
> > > >> On Thu, Oct 16, 2008 at 8:25 PM, joe <[EMAIL PROTECTED]> wrote:
>
> > > >> > Hi.
>
> > > >> > I am trying to use the criteria API to eager fetch a many to one
> > > >> > property.
>
> > > >> > ICriteria criteria =
>
> > NHibernateSession.CreateCriteria(typeof(Customer)).Add(Expression.Eq("ID",
> > > >> > id));
> > > >> > criteria.SetFetchMode("State", FetchMode.Eager);
> > > >> > return criteria.UniqueResult<Customer>();
>
> > > >> > The generated sql does do the join in order to retrieve the "State"
> > > >> > association property, however, my customer object's state property
> > is
> > > >> > not initialized (it is not null but only the id is set).
>
> > > >> > Am i missing something ?
>
> --
> Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
