NH Linq and SelectMany

[Matthieu Guyonnet-Duluc]

I narrow my previous problem to this query :

IQueryable<Address> adresses = session.Linq<Subscriber>().Where(s => s.Id == new Guid("7af42422-ef0d-4368-a2a9-0bc2e9b0fd32")).SelectMany(s => s.Addresses);

I got a invalid cast exception (from Adress to Subscriber).

It seems that the SelectMany is not properly translated : in the method HandleSelectManyCall of NHibernateQueryTranslator this condition is not true for my call if (call.Arguments.Count == 3).

 

I've attached a console project with the query and the database used.

 

Matthieu

 

[Fabio Maulo]

JIRA ?

2008/9/18 Matthieu Guyonnet-Duluc <matth...@gmail.com>

--
Fabio Maulo

[matthieuGD]

done

http://jira.nhibernate.org/browse/NHLQ-16

Matthieu

[Tuna Toksöz]

I have tried to put a support for this, but i think it is a limitation of criteria.

On Fri, Sep 19, 2008 at 10:37 AM, matthieuGD <matth...@gmail.com> wrote:

done

http://jira.nhibernate.org/browse/NHLQ-16

Matthieu

--
Tuna Toksöz

Typos included to enhance the readers attention!

[Matthieu Guyonnet-Duluc]

What do you mean by limitation of criteria ?

 

Matthieu

[Tuna Toksöz]

You cannot project on a List

I mean

class MyEntity

{

    List<T> MyCollection{get;}

}

Since it is using Criteria api behind the scenes, and if I do it like this 

select x.Addresses

it will try to do SetProjection(Projections.Property("MyCollection")) which will not work

Does it? I may be wrong, don't know.

[Fabio Maulo]

2008/9/19 Matthieu Guyonnet-Duluc <matth...@gmail.com>

What do you mean by limitation of criteria ?

The version of NHibernate.LINQ you are using (version hosted in NH.Contrib and previous in Rhino) is base on Criteria:

LINQ->Criteria->SQL

This mean that it suffer of the limits of Criteria API.

In the trunk we start a new project (NH2LINQ). Tuna Toksoz and Chad Lee are working on it.

The target of the new prj is allow you to use all features supported by LINQ and extend it with all feature supported by HQL (instead limit LINQ because CriteriaAPI).

--
Fabio Maulo

[Matthieu Guyonnet-Duluc]

On Fri, Sep 19, 2008 at 4:56 PM, Fabio Maulo <fabio...@gmail.com> wrote:

 

In the trunk we start a new project (NH2LINQ). Tuna Toksoz and Chad Lee are working on it.

The target of the new prj is allow you to use all features supported by LINQ and extend it with all feature supported by HQL (instead limit LINQ because CriteriaAPI).

--
Fabio Maulo

 

Ok thanks you for the information ! With all the website and forums official or uniofficial between red hat, google groups, source forge, nhforge etc ...Sometimes  I'm kind of lost to find the correct documentation / news :)

 

Matthieu

[Tuna Toksöz]

nhusers is the place to ask questions and NHForge is place for all nh-related stuff(wikis, blogs, etc).

sourceforge is for downloading releases.