CollectionSubqueryFactory.cs

using System;
using System.Collections.Generic;
using System.Text;
using NHibernate.Engine;
using NHibernate.SqlCommand;

namespace NHibernate.Hql
{
	public class CollectionSubqueryFactory
	{
		public static string CreateCollectionSubquery(
			JoinSequence joinSequence,
			IDictionary<string, IFilter> enabledFilters,
			String[] columns)
		{
			try
			{
				joinSequence.SetUseThetaStyle(true);
				JoinFragment join = joinSequence.ToJoinFragment(enabledFilters, true);
				return new StringBuilder()
					.Append("select ")
					.Append(string.Join(", ", columns))
					.Append(" from ")
					.Append(join.ToFromFragmentString.Substring(2)) // remove initial ", "
					.Append(" where ")
					.Append(join.ToWhereFragmentString.Substring(5)) // remove initial " and "
					.ToString();
			}
			catch (MappingException me)
			{
				throw new QueryException(me);
			}
		}
	}
}