Devart Forums

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

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.

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