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

I know LINQ-to-NHibernate currently does not support sub-queries (http://ayende.com/Blog/archive/2009/07/26/nhibernate-linq-1.0-released.aspx).

Is there any workaround about it?

Answers


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 http://afsharm.blogspot.com/2010/03/dealing-with-subqueries-in-linq-to.html 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.