LINQ queries seem to run once and reuse the selected data if the parameters don't change. - even it the data underneath has changed. In this code the query data is not refreshed eventhough I have changed the data in the database and I want to get the refreshed data.
'** Load Default MWH Data
Private Sub LoadDefaultMWH()
'* DataContext is dc_MD
'* Table is MD_MeterPoints
Dim wrkMWH As Double
'** Load Selected Date data
Dim qDM = From DM In dc_MD.MD_MeterPoints _
Select DM Where DM.P_ID = 210
For Each recDM In qDM '* there is only 1 record
wrkMWH = recDM.P_DefaultAvailibility
How can I get LINQ to go back to the database when it thinks it already has what I want?