LINQ query with Distinct() throws error

[Matt]

Hi all,
I'm trying to bind a LINQ query that has a Distinct() in it and bind it to a Grid (this is the Telerik grid still, haven't converted to Kendo yet). I've tried adding AsQueryable() to it also, but still getting a "Specified method is not supported exception."

My query looks like this:

var rewardTypes = (from type in _rewardTypeRepository.GetAll()
                               from vo in type.ValidOutlets
                               join ot in _outletRepository.GetAll()
                                   on vo.Outlet.Id equals ot.Id
                               where userOutletIds.Contains(ot.Id)
                               select vo.RewardType).Distinct().AsQueryable();

Any ideas or guidance on this would be greatly appreciated.

Thank you,
Matt

[Petur Subev]

Hello Matt,

I am not sure if the error is directly related to the Grid. Does the same error appear if you append the ToList() extension method to your query ?

Kind Regards,
Petur Subev
the Telerik team