Error in projection

Given the following query going to MSSQL, I get the error "The method 'Select' is not supported". The query works in LINQPad using LINQ to SQL. I have to break the query out and iterate over the Locations and then execute the projected query to get this to work.

                from l in UnitOfWorkScope.Current.Locations
                select new SelectedLocation
                    {
                        LocationId = l.Id,
                        Selected =
                            (from cl in UnitOfWorkScope.Current.CollectorLocations
                            where cl.CollectorId == new Guid(collectorId) && cl.LocationId == l.Id
                            select cl).Any()
                    };

Hi Dan,

Yes currently projections which contain a seperate query are not supported, so your use of the Selected property is causing the error when trying to translate the method calls (Where/Select) inside that statement. As you have pointed out, currently you will need to break this out into seperate queries as a workaround for now.

We have a backlog item for adding support in for this in the future, so I will post an update once we have this available in a release :)

Jeremy

Jeremy,

Is this one still on the backlog?

John

Yes, this is still on the backlog. I am doing some work on improved translation in the LINQ provider for 5.0 so this may be resolved as part of that, but will keep you posted :)

Jeremy