Query() Result holds old data

[enchev]

Yes, there is a EF cache that can be avoided like this:

EF cache and data fetch

I have a table that has a db trigger which updates a field in a related table upon value from the field within the table. When this happened EF cache retained old values and users could not see any changes. Is it possible to force GetTABLE() method to read directly from db instead of ef cache?