title: LinqToSql associations loading
body: <p>This may have been asked already, but I can't find it, so here goes.</p>
  
  <p>We have a generic read of a table, using Context.GetTable( ) and then attaching an expression to find the single record in the table. This table has associations. Unfortunately, we're trying to change a field on which an association is made, so;</p>
  
  <p>Foo is parent of Bar on FooId</p>
  
  <p>When we're going to change the FooId, it's crashing because the HasAlreadyLoaded property of the EntityRef is set to true. Unless I'm not understanding LinqToSql well enough, I believe it's the act of calling SingleOrDefault on this recordset that is actually firing the query and thus loading all the associated objects up.  </p>
  
  <p>Is there a way to stop this loading occuring? (ObjectTrackingEnabled and DeferredLoading set to true) and if not what is the common solution for this problem? We don't know about individual relationships at this point, and I don't want to have to look at the possibility of going figuring out the associations and loading them up based on the id. </p>
  
  <p>My preferred method would have been a less generic one, and I could have done .Foo = Context.Foo.Select( x => x.Id == FooId ), but we don't have that luxury now.</p>