Hibernate Books

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: BaseDataProvider<T> fetching duplicate rows
PostPosted: Thu Feb 02, 2012 6:54 am 
Newbie

Joined: Thu Feb 02, 2012 6:38 am
Posts: 1
I've an Entity named "vwAutoTaskInvoicesList", It's a view in sql server. I just want to fetch all rows in form of an IList<vwAutoTaskInvoicesList>.
This seem simple, but when I did this.
Code:
IList<vwAutoTaskInvoicesList> invoices = BaseDataProvider<vwAutoTaskInvoicesList>.GetList();

I am getting all rows but duplicate. There is field in vwAutoTaskInvoicesList called "WorkOrderID" and what I want is to fetch invoices of the given WorkOrder ID. Now, if there are 2 invoices for a given WorkOrder ID this query also fetches 2 invoices but it repeats the first one. And if there are 3 invoices it will repeat the first one 3 times. I don't know whether there is a flaw on my side or it's a bug in NHibernate. Kindly help me to overcome this problem. Thanks.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.