Hi, I have a very strange problem.
I created a complex view in SQL Server and mapped this View to a Open Access Class, say VContacts.
The problem is that when I execute this request...
|var contacts = from c in scope.Extent<VContacts>() |
| select c; |
...the result is not correct, I get the number of rows I should get, but they are the same instead of different ones.
I traced the request to get the SQL query sent to SQL Server, I copied this query in a SQL Server query editor and I got the right result. (the rows are not the same).
I tried to do the same query using an oql query, and the result is the same: Looking at the Open Access logs, the right query is sent to Sql Server, but in the List<Contacts> I get, I have the right number of items, but they are the same...
Do you know where that problem could come from ? Is there an extra step between the result coming from the query sent to SQL Server (which seems to be right, according to Open Access Logs) and the populating of the actual result container ?