NotSupportedException: Unsupported overload used for query operator 'Select'”

Solution:
use Enumerable.Select with AsEnumerable.

?

var results = tmp.AsEnumerable()                  .Select((row, index) => new { row.ContainerID, row.TypeID,                                                ContainerIndex = index });