title: Anonymous Type with Linq and Guid
body: <p>I have a simple table: <br /></p>
  
  <p>ID   |   Value</p>
  
  <p>When I do this:</p>
  
  <pre><code>var sequence = from c in valuesVault.GetTable()
                 select new {RandomIDX = Guid.NewGuid(), c.ID, c.Value};
  </code></pre>
  
  <p>each element in the projection has the value of the same guid... How do I write this so that I get a different random guid value for each of my element in the projection?</p>
  
  <p><b>Edit</b></p>
  
  <p>To clarify on the issue. The <b> GetTable() </b> method simply calls this:</p>
  
  <pre><code>        return this.context.GetTable&lt;T&gt;();
  </code></pre>
  
  <p>where the this.contenxt is the DataContext of type T.</p>
  
  <p>The itteration is done as it's always done, nothing fancy:</p>
  
  <pre><code>     foreach (var c in seq) 
       {
            Trace.WriteLine(c.RandomIDX + " " + c.Value);
       }
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>bf59c94e-119c-4eaf-a0d5-3bb91699b04d What is/was your mother's maiden name?
  bf59c94e-119c-4eaf-a0d5-3bb91699b04d What was the last name of one of your high school English teachers?
  bf59c94e-119c-4eaf-a0d5-3bb91699b04d In elementary school, what was your best friend's first and last name?
  </code></pre>
  
  <p><b>Edit 2</b>
  Using out the box linq2Sql Provider. I had built some generic wrappers around it but they do not alter the way IQuaryable or IEnumerable function in the code.</p>