You are doing it wrong.
Can you see the problem? How can you talk about *batchsize* and show this
nasty thing
<sql-insert>
INSERT INTO [Price]
([EffectiveDate]
,[CurrencyId]
,[UnitOfPriceId]
,[AgreementId]
,[Amount]
,[PriceStatusId])
VALUES
(?,?,?,?,?,?);
select SCOPE_IDENTITY()
</sql-insert>
2010/4/23 robcar <[email protected]>
> Sorry if this looks bad (I'm a newbie in posting questions here
> too :-)
>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> assembly="Entities" namespace="Entities">
> <class name="Price" table="[SelectPricesView]">
>
> <id name="PriceId" column="PriceId" type="System.Int32" unsaved-
> value="0">
> <generator class="identity"/>
> </id>
>
> <property name="EffectiveDate" column="EffectiveDate" not-
> null="true" type="System.DateTime" insert="true" update="true"/>
> <property name="NextEffectiveDate" column="NextEffectiveDate" not-
> null="true" type="System.DateTime" insert="false" update="false"/>
> <many-to-one name="Currency" fetch="select" lazy="proxy" not-
> null="true" outer-join="auto" insert="true" update="true">
> <column name="CurrencyId"/>
> </many-to-one>
> <many-to-one name="UnitOfPrice" lazy="false" fetch="select" not-
> null="true" outer-join="auto" insert="true" update="true">
> <column name="UnitOfPriceId"/>
> </many-to-one>
> <many-to-one name="Agreement" fetch="join" not-null="true" outer-
> join="auto" insert="true" update="true">
> <column name="AgreementId"/>
> </many-to-one>
> <one-to-one name="PriceSearchFacilitator"
> class="PriceSearchFacilitator" fetch="join"/>
> <set name="PreviousPriceSearchFacilitator" inverse="true"
> cascade="none" lazy="true" fetch="subselect" generic="true" >
> <key column="PreviousPriceId" />
> <one-to-many class="PreviousPriceSearchFacilitator"/>
> </set>
>
> <!--<one-to-one name="PreviousPriceSearchFacilitator"
> class="PreviousPriceSearchFacilitator" fetch="join"/>-->
> <property name="Amount" column="Amount" not-null="true"
> type="System.Decimal" insert="true" update="true"/>
> <property name="Status" column="PriceStatusId" not-null="false"
> insert="true" update="true"/>
> <!-- <set name="CostComponents" inverse="true" cascade="all-
> delete-orphan" lazy="true" fetch="subselect" generic="true" >-->
> <set name="CostComponents" inverse="true" cascade="all-delete-
> orphan" lazy="false" fetch="join" generic="true" >
> <key column="PriceId" />
> <one-to-many class="CostComponent"/>
> </set>
>
> <sql-insert>
> INSERT INTO [Price]
> ([EffectiveDate]
> ,[CurrencyId]
> ,[UnitOfPriceId]
> ,[AgreementId]
> ,[Amount]
> ,[PriceStatusId])
> VALUES
> (?,?,?,?,?,?);
> select SCOPE_IDENTITY()
> </sql-insert>
> <sql-update>
> UPDATE [Price]
> SET [EffectiveDate] = ?
> ,[CurrencyId] = ?
> ,[UnitOfPriceId] = ?
> ,[AgreementId] = ?
> ,[Amount] = ?
> ,[PriceStatusId] = ?
> WHERE PriceId = ?
> </sql-update>
> <sql-delete>
> DELETE FROM [Price]
> WHERE PriceId=?
> </sql-delete>
>
> </class>
>
>
> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
> assembly="Entities" namespace="Entities">
> <class name="CostComponent" table="CostComponent" abstract="true"
> discriminator-value="null" >
> <id name="CostComponentId" column="CostComponentID"
> type="System.Int32" unsaved-value="0">
> <generator class="identity"/>
> </id>
> <discriminator column="IsIncluded" type="System.Boolean"/>
>
> <property name="Amount" column="Amount" not-null="true"
> type="System.Decimal" insert="true" update="true"/>
> <many-to-one name="Type" fetch="select" lazy="false" not-
> null="true" outer-join="auto" insert="true" update="true">
> <column name="CostComponentTypeId"/>
> </many-to-one>
>
> <many-to-one name="Price" column="PriceId" not-null="true"/>
>
> <subclass discriminator-value="True" name="IncludedCostComponent">
> </subclass>
>
> <subclass discriminator-value="False" name="AddedCostComponent">
> </subclass>
>
> </class>
>
> </hibernate-mapping>
>
> On 23 Apr, 14:55, José F. Romaniello <[email protected]> wrote:
> > Can you show the mappings?
> >
> > --
> > 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]<nhusers%[email protected]>
> .
> > For more options, visit this group athttp://
> groups.google.com/group/nhusers?hl=en.
>
--
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.
