[nhibernate-issues] [NHJIRA] Commented: (NH-2688) SelectMany with cast throws QuerySyntaxException

[Andrew M. (JIRA) <nh...@gm...>]

    [ http://216.121.112.228/browse/NH-2688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21150#action_21150 ] 

Andrew Michell commented on NH-2688:
------------------------------------

Any updates on this issue?

It is also blocking my team from using NHibernate as a linq provider for WCF data services.

dabuddhaman, as a workaround it might be possible to wrap the NHibernate linq provider with your own provider so you can inspect the expression tree and remove the convert expression.

> SelectMany with cast throws QuerySyntaxException
> ------------------------------------------------
>
>                 Key: NH-2688
>                 URL: http://216.121.112.228/browse/NH-2688
>             Project:  NHibernate
>          Issue Type: Bug
>          Components: Linq Provider
>    Affects Versions: 3.2.0Alpha2
>            Reporter: dabuddhaman
>            Priority: Major
>         Attachments: SelectManyWithCastThrowsQuerySyntaxException.cs
>
>
> When trying to implement WCF dataservices using NHibernate I had a blocking error.
> the call to 
> http://localhost:32774/NorthWindNHibernateDataService.svc/Orders(4)/OrderLines
> generated the following Linq query
> db.Orders.Where(element => element.OrderId == 4).SelectMany(element => (IEnumerable<OrderLine>)element.OrderLines)
> //{value(NHibernate.Linq.NhQueryable`1[OrderLines]).Where(element => (element.OrderId == 4)).SelectMany(element => Convert(element.OrderLines))}
> which throws a QuerySyntaxException

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://216.121.112.228/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira