Resolving lazily faulted to-one and to-many relationships can be out-of-date when you expect up-to-date data from database.
This happened because of getting data from snapshot cache instead of database.
1) Create context
2) Select Artist from database, then get artist's paintings
3) direct update painting table
4) Create new context
5) Do step 2
Painting from step 5 is not updated.