Entity Framework repeats results

Question

0.00/5 (No votes)

See more:

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.

Posted 11-Nov-15 10:30am

Member 11757010

Add a Solution

Comments

Richard Deeming 11-Nov-15 16:44pm

By "the same results", do you mean you don't see new records in the list, and deleted records still show?

Or do you mean that you don't see updates to the existing records that you've already loaded?

Member 11757010 11-Nov-15 17:41pm

I mean I don't see updates made in the DB. (I have not try with new and deletes items yet)
Ex.
Run Query and get x results.
Change some data in DB.
Run again Query and get the same x results.

If I End the program and run again for the first time that Query I got the updated results.

It is like that Query fetch the data from db at first but then it obtains results from some cache or so.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dave Kreskowiak · Accepted Answer · 2015-11-11T11:56:00

You're not showing the entire ball of code, but what I think you're doing is creating a context instance when your app starts and then never destroying it until your app exists.

DO NOT DO THIS. Create a context instance when you need to query the data and then dispose the context when your done with in.

EF caches everything it sees from the database. If you request an entire table, the entity tracker loads every record in the table and rehydrates it in memory. All future requests for that data come from the tracker, not the database.

Your code should look more like this:

Dim result As IEnumerable(Of Product)
Using (context As MyDbContext = new MyDbContext())
    result = context.Products.ToList()
End Using

Krunal Rohit · Accepted Answer · 2015-11-11T18:18:00

EF caches your database.
Your class should implement IDisposable interface. Or you can define the scope for using the EF context.

VB

Using (db As MyDbEntities = new MyDbEntities())
    result = contedbxt.Products.ToList()
End Using

I'd suggesst you to use Repository Pattern whenever you're working with the EF.
Repository Pattern with Entity Framework using EntityTypeConfiguration[^]

-KR

Entity Framework repeats results

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0