non-managed entities ? correct me if iam wrong
On Jun 5, 9:36 am, Vels <[email protected]> wrote:
> it is mapped only
> Stock.hbm.xml
> Stock.vb
>
> but i am not having Stock table,loading the objects via Stored
> procedure..
>
> On Jun 4, 7:59 pm, Fabio Maulo <[email protected]> wrote:
>
>
>
> > If the class should be unmapped why you have wrote the mapping ?
>
> > 2009/6/4 Vels <[email protected]>
>
> > > Hi..,
>
> > > i want to update store procedure results to unmapped class (stock)
> > > Mapping info:
> > > <class name="Stock">
> > > <id (What should be here)</id>
> > > <many-to-one name="Item" class="Item" column="ItemCode"
> > > fetch="join" update="false"/>
> > > <property name="ReceiptQty" update="false" />
> > > <property name="IssuedQty" update="false" />
> > > <property name="BalanceQty" update="false" />
> > > </class>
>
> > > <sql-query name="prcGetItemsStock">
> > > <return class="Stock" alias="Stock">
> > > <return-property column="ItemCode" name="Item" />
> > > <return-property column="ReceiptQty" name="ReceiptQty" />
> > > <return-property column="IssuedQty" name="IssuedQty" />
> > > <return-property column="BalanceQty" name="BalanceQty" />
> > > </return>
> > > exec dbo.prcGetItemsStock
> > > </sql-query>
>
> > > My Store Procedure :
>
> > > ALTER PROCEDURE [dbo].[prcGetItemsStock]
> > > AS
> > > BEGIN
> > > SELECT ItemCode, SUM(ReceiptQty) AS ReceiptQty, SUM(IssuedQty) AS
> > > IssuedQty, SUM(ReceiptQty - IssuedQty) AS BalanceQty
> > > FROM (SELECT ItemCode, ProperQty AS ReceiptQty, 0 AS IssuedQty
> > > FROM tblReceiptDetails
> > > UNION ALL
> > > SELECT ItemCode, 0 AS ReceiptQty, IssuedQty AS Qty
> > > FROM tblIssueDetails) AS dt
> > > GROUP BY ItemCode
>
> > > Function RetriveByQuery(Of T)(ByVal Query As String) As List(Of T)
> > > {
> > > Dim s As ISession = GetSession(GetType(T))
> > > Dim iQry As IQuery = s.GetNamedQuery(Query)
> > > iQry.SetResultTransformer(Transformers.AliasToBean(GetType(T)))
> > > Return iQry.List(Of T)()
> > > }
>
> > > the iQry.List(Of T)() is fetcing the correct number of records but all
> > > the records are having the same value of the first record
> > > i.e for first object, it is creating instance and updating the values,
> > > but for the reset of the objects it is not creating an instance
>
> > > e.g
> > > (Query result)
> > > Property Value
> > > S1
> > > S2
> > > S3
>
> > > after excuting iQry.List(Of T)()
> > > S1
> > > S1
> > > S1
>
> > > i referred
>
> > >http://nhforge.org/blogs/nhibernate/archive/2008/11/24/populating-ent...
>
> > > can you help me where i missed ?
>
> > > NH Version : 2.1.0
> > > VB.Net 3.5
> > > SQL 2005
>
> > --
> > Fabio Maulo- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
