title: LINQ join to collection using index
body: <p>We have a basic collection containing strings and we would like to use LINQ to join to this collection based on an int returned from the database (in the same linq statement) but the collection does not have an "index" as such, so we were hoping we could simply reference the index of the collection ie. where the item is placed within the collection.</p>
  
  <p>In simple terms outside of linq we would do</p>
  
  <pre><code>string MyString = MyCollection[MyIndex];
  </code></pre>
  
  <p>but this is not supported inside LINQ.</p>
  
  <p>Any help would be appreciated.</p>