Entity Framwork repeats the same results

[LeoVBNET]

Hi
I have used Linq to SQL for a long time, but now, because I need to work with MySQL I had to start with Entity FrameWork.
I combine ADO.NET and EF and I did not realize about this issue, but recently, I had found a very big problem that it`s driving me crazy.

A simple query...

Dim Query = (From p in db.products select p).ToList

It gives the results the first time good, but when I run this query again, it gives the SAME RESULTS again and again !!!

I mean, any change in the database it is not reflected in that query. The only way is to quit program and run again.

Visual Basic - VS2013
Entity Framework 5.0 (MySql)

Thanks.

[Ammarhassan48]

There might some mistake in your logic . Can you show the piece of code that is not working ?

[LeoVBNET]

Hi
The mystery has been solved:

EF caches the database. So, it is very important to make a context when needed and then dispose it.

Using DBEntity As New DBEntityModel()
   ....
    ....
End Using
 

Thanks!