Is there any work-around for NHibernate-to-LINQ not supporting subqueries?

I know LINQ-to-NHibernate currently does not support sub-queries (

Is there any workaround about it?


linq-to-nh DOES support sub queries in where clause. It is exact thing I needed. I was wrong with my previous answer. Both martijnboland and Stefan Steinegger were right. To see how you do sub-queries in linq-to-nh see this and this. There is also limitations.

I think the workaround is simply to use HQL or Criteria.

I have not worked with nhibernate to linq but i'm sure that you can translate almost any subquery to a join

I have used a two part LINQ query as a work around. A LINQ-to-NHibernate for not related sub query section and a LINQ-to-Object for sub query related section of the query. Please see for more detail.

Need Your Help

What's the changes between developing for the iPhone and the iPhone 4?

iphone objective-c retain

Hey, I'm working on an iPhone app but I've heard from some people that it's a size difference between the iPhone and the iPhone 4 and if it's not iPhone 4 committable to use the retain display it w...

how to add subview over storyboard?

objective-c ios xcode storyboard subview

I have a ViewController and I want to add 3 subviews in the content part.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.