solved...using composite-id and little me code
<class name="Stock">
<composite-id>
<key-property name="StoreCode"/>
<key-property name="ItemCode"/>
</composite-id>
<many-to-one name="Store" class="Store" column="StoreCode"
update="false"/>
<many-to-one name="Item" class="Item" column="ItemCode"
update="false"/>
<property name="ReceiptQty" update="false" />
<property name="IssuedQty" update="false" />
<property name="BalanceQty" update="false" />
</class>
SQL View:
SELECT StoreCode,ItemCode, SUM(ReceiptQty) AS ReceiptQty, SUM
(IssuedQty) AS
IssuedQty, SUM(ReceiptQty - IssuedQty) AS BalanceQty
FROM (SELECT StoreCode,ItemCode, ProperQty AS ReceiptQty, 0 AS
IssuedQty
FROM tblReceiptDetails
UNION ALL
SELECT StoreCode,ItemCode, 0 AS ReceiptQty, IssuedQty AS
Qty
FROM tblIssueDetails) AS dt
GROUP BY StoreCode,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.CreateSQLQuery(Query).AddEntity(GetType(T))
iQry.SetFlushMode(FlushMode.Never)
iQry.SetResultTransformer(Transformers.AliasToBean(GetType(T)))
Return iQry.List(Of T)()
}
Cheers,
-vels-
On Jun 5, 12:27 pm, Vels <[email protected]> wrote:
> 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 -- 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
-~----------~----~----~----~------~----~------~--~---
