It looks like you've created an entity type to represent the values returned from your view, and you've set the
Count
column as the primary key for that type.
EF uses the
Identity map pattern[
^]. When it tries to load the third row (Count = 2), it thinks that it has already loaded that record. It ignores the data from the database, and returns the already-loaded entity instead.
You need to change the entity type to have a composite primary key based on
sDate
and
Count
instead. And if that combination of columns isn't unique, then you'll need to add a new unique column to your view, and set that as the primary key on your entity type.
sql - Using a view with no primary key with Entity - Stack Overflow[
^]