Repetative data while browsing the recordset...

Repetative data while browsing the recordset...

Postby RajeevDebnath » Mon 14 Mar 2011 10:14

Hi,

I am one of the user of dotConnect.

I have view and that view I am accessing from the Silverlight and view contains the data in the below format

EMPID ------ SUPPID ---- UAR ID - BLOB Data
4 S0001 12345 -
4 S0002 54678 -
5 S0034 78998 -
5 S0001 78887 -
5 S0038 98678 -

while retreiving from Silverlight I am getting the same data for the next record until EMPID is same, below is the recordset which I am getting from silverlight

EMPID ------ SUPPID ---- UAR ID - BLOB Data
4 S0001 12345 -
4 S0001 12345 -
5 S0034 78998 -
5 S0034 78998 -
5 S0034 78998 -

Please let me know why I am not getting same field values from next record onwards.

Please let me know if you need any further input

Thanks,
Rajeev
RajeevDebnath
 
Posts: 14
Joined: Mon 07 Feb 2011 09:02

Postby AndreyR » Mon 14 Mar 2011 13:27

Does the Entity Key of the view consist only of the EMPID property?
Entity Framework performs entity caching, and it does not fetch a record again if it already has a loaded entity with the same Entity Key value.
Try to add SUPPID to Entity Key of the view.
Please let us know if this piece of advice isn't helpful.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby RajeevDebnath » Tue 15 Mar 2011 07:21

Thanks for the suggestion, after adding the multiple that issue got resolved.
RajeevDebnath
 
Posts: 14
Joined: Mon 07 Feb 2011 09:02


Return to dotConnect for Oracle