Repetative data while browsing the recordset...

RajeevDebnath · Post by **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

AndreyR · Post by **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.

RajeevDebnath · Post by **RajeevDebnath** » Tue 15 Mar 2011 07:21

Thanks for the suggestion, after adding the multiple that issue got resolved.