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 });