Did You solve this problem?
On 10 jul., 17:59, "Cesar Sanz" <[email protected]> wrote:
> Sure...
>
> Operator
>
> <?xml version="1.0" encoding="utf-16"?>
> <hibernate-mapping auto-import="true" default-lazy="false"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xmlns="urn:nhibernate-mapping-2.2">
> <class name="Sms.Data.Domain.Operator, Sms.Data.Domain" table="operators"
> schema="dbo" lazy="true">
> <id name="Id" access="property" column="Id" type="Int32"
> unsaved-value="0">
> <generator class="native"></generator>
> </id>
> <property name="Name" access="property" type="String">
> <column name="Name"/>
> </property>
> <bag name="Clients" access="property" table="clients" lazy="false"
> inverse="true" cascade="all-delete-orphan">
> <key column="Operator" />
> <one-to-manyclass="Sms.Data.Domain.Client, Sms.Data.Domain" />
> </bag>
> </class>
> </hibernate-mapping>
>
> Client
>
> <?xml version="1.0" encoding="utf-16"?>
> <hibernate-mapping auto-import="true" default-lazy="false"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema";
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> xmlns="urn:nhibernate-mapping-2.2">
> <class name="Sms.Data.Domain.Client, Sms.Data.Domain" table="clients"
> schema="dbo">
> <id name="ClientId" access="property" column="Id" type="Int32"
> unsaved-value="0">
> <generator class="native"></generator>
> </id>
> <property name="AreaCode" access="property" type="String">
> <column name="AreaCode"/>
> </property>
> <property name="Cif" access="property" type="String">
> <column name="Cif"/>
> </property>
> <property name="Identification" access="property" type="String">
> <column name="Identification"/>
> </property>
> <property name="FirstName" access="property" type="String">
> <column name="FirstName"/>
> </property>
> <property name="LastName" access="property" type="String">
> <column name="LastName"/>
> </property>
> <property name="LastName2" access="property" type="String">
> <column name="LastName2"/>
> </property>
> <property name="Email" access="property" type="String">
> <column name="Email"/>
> </property>
> <property name="Notify" access="property" type="Boolean">
> <column name="Notify"/>
> </property>
> <property name="Status" access="property">
> <column name="Status"/>
> </property>
> <property name="ModifiedBy" access="property" type="String">
> <column name="ModifiedBy"/>
> </property>
> <property name="CreatedAt" access="property" type="DateTime">
> <column name="Created"/>
> </property>
> <property name="ModifiedAt" access="property" type="DateTime"
> insert="false">
> <column name="Modified"/>
> </property>
> <property name="CellPhone" access="property" type="String">
> <column name="CellPhone"/>
> </property>
> <many-to-onename="Operator" access="property"
> class="Sms.Data.Domain.Operator, Sms.Data.Domain"
> column="Operator"fetch="join" />
> <bag name="Products" access="property" table="products" lazy="true"
> inverse="true" cascade="all-delete-orphan">
> <key column="ClientId" />
> <one-to-manyclass="Sms.Data.Domain.Product, Sms.Data.Domain" />
> </bag>
> </class>
> </hibernate-mapping>
>
>
>
> ----- Original Message -----
> From: "Eyston" <[email protected]>
> To: "nhusers" <[email protected]>
> Sent: Friday, July 10, 2009 9:35 AM
> Subject: [nhusers] Re: HQL Join Problem
>
> Can you show mappings?
>
> On Jul 10, 11:12 am, spiralni <[email protected]> wrote:
> > Hi..
>
> > I'd like to perform a join between two entities..
>
> > [Operator] hasmany[Client]
>
> > I can do this with this SQL sentence
>
> >selectc.*, o.name from clients c join operators o on c.operator =
> > o.id
>
> > I would like to do this same query using HQL, for this I use this HQL
> > query
>
> > "from Client c joinfetchc.Operator where c.Status = :status and
> > c.Cif in (:cifs)"
>
> > The HQL query results in
>
> >select(fields names goes here)
> > from dbo.clients client0_ inner join dbo.operators operator1_ on
> > client0_.Operator = operator1_.Id
> > where (client0_.Status = 1) and (client0_.Cif in (12345670 ,
> > 12345678 ))
>
> > which is ok, but also execute a new query for every operator id that I
> > have (in my case I have 2 operators)
>
> >SELECT(fields names goes here)
> > FROM dbo.clients clients0_
> > WHERE clients0_.Operator = 2
>
> >SELECT(fields names goes here)
> > FROM dbo.clients clients0_
> > WHERE clients0_.Operator = 1
>
> > Which is not desirable... Why is this happening..? I just want to
> > execute the first query..
>
> > Hope you can help me..
>
> > Thanx
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
