Load() does not refresh all changes

See more:

C#

entity-framework

Hello,

I have this strange problem:

You have a database with these rows:

Table: Letter

Id=1,Name="A"
Id=1,Name="B"
Id=1,Name="C"

Now you make the query

var q= (from l in context.Letter where l="A" select l);
g.Load();

Now in context.Local yo have only one row (the first one)

If you go to database and remove or delete or add files, the Local refresh accordingly (you must use Load() and Refresh() between changes).

But in this case it does not work, see it:

You go to database and change "A" to "B" and repeat the query

g.Load();

The entity changes his value to "B" so it must been removed from Local but it stills alive in Local (count==1) when the local must have 0 elements (count==0)

Any idea?