Hi i'm trying to setup simple test data.
I simply want to take a collection which is smallish and make it bigger by add itself multiple times.
After I;ve added them together i want to re-number the property LineNumber so that there are no duplicates and that it goes in order. 1,2,3,4....
no matter what i try it doesn't seem to work and i cant see the mistake.
var sampleTemplateLine = dataContext.TemplateFileLines.ToList();
*//tired this doesnt work either*           
//List<TemplateFileLine> lineRange = new List<TemplateFileLine>();
//lineRange.AddRange(sampleTemplateLine);
//lineRange.AddRange(sampleTemplateLine);
//lineRange.AddRange(sampleTemplateLine);
//lineRange.AddRange(sampleTemplateLine);
var allProducts = sampleTemplateLine
                       .Concat(sampleTemplateLine)
                       .Concat(sampleTemplateLine)
                       .Concat(sampleTemplateLine)
                       .ToList();
int i = 1;
foreach (var item in allProducts)
{
     item.LineNumber = i;
     i++;
}
this doesnt seem to work either
  //re-number the line number
  var total = allProducts.Count();
  for (int i =0; i < total; i++)
  {
      allProducts[i].LineNumber = i+1;
  }
PROBLEM: below RETURN 4 when i'm expecting 1
var itemthing = allProducts.Where(x => x.LineNumber == 17312).ToList();
 
     
    