title: Linq to SQL though refreshing context object not updated when using SP with merge
body: <p>I've built unit tests for SP heavy sql server (2008) database using Linq to SQL. In short I begin a transaction during test initialization and in clean up these are rolled back.</p>
  
  <p>This has worked fine so far. I've been able to verify the changes in db-rows as long as I've remembered to refresh the objects used.</p>
  
  <p>Yesterday I wrote my first unit test for SP using <a href="http://msdn.microsoft.com/en-us/library/bb510625.aspx" rel="nofollow">merge</a>. I'm able to verify the insert, but though I refresh the object with the updated row, the refreshed object is not updated with the changes. Has anyone experienced similar problems? Is there a workaround for this. </p>
  
  <p>I've verified that the update works when running the SP outside unit tests.</p>