Retrieving Updated Data Using LINQ to SQL

I know that when repeating in an IQueryable variable, the query is sent to the database, but if the data is updated in the database, new data is not displayed during the iteration until Refresh is called in the DataContext.

So, what is the reason for always sending a query to the database if the updated data is not available, and is there a way to always show the updated data automatically without calling Refresh all the time?

I understand one advantage is that it returns newly added records, but what about an updated one?