LINQ Resultset Issue

Question

I built a site using LINQ and it has started to show issues with the results it brings up.

The results brought out by the query do not reflect the data in the database, they reflect an older version of the database.

In all the places where the LINQ data context was created it was disposed off properly. The sample code used in the site looks like this

 using (DataClassesDataContext context = new DataClassesDataContext()) 
 {
     return (<query here>).Distinct().ToList();
 }

Answer 1

Check the generated SQL at runtime when debugging, and check the results against your database...

Also check your connection strings, maybe your DataContext is connecting to another database...