I am having one Oracle view and using Entity Framework 4 to retrieve data from it. I fetch the data from Entity Framework's context using linq query.
Problem is - If there are two matching records for the applied query, then I get the two rows but both rows are the same i.e. both rows contains data from first row.
It is returning correct number of records but all records all same (i.e. first row data). All records have same set of data which is there in the first row.
I verified in the database, proper records are there and in query window correct data is retrieved. Problem is there only when I fetch data from code via EF.
Please suggest on how to fetch correct set of data.