Now it works!
After updating NHibernate it seems to work.
I made some changes to your suggestion and the final code look like
this:
DetachedCriteria detac=DetachedCriteria.For<Test2>("TAR")
.Add(Restrictions.EqProperty("TAR.Test.Id", "T.Id"))
.Add(Restrictions.Gt("TAR.Datetime", DateTime.Now.AddDays
(-1)))
.SetProjection(Projections.Count("Test.Id"));
ICriteria crit = session.CreateCriteria(typeof(Test),"T");
crit.AddOrder(Order.Desc(Projections.SubQuery(detac)));
Thank you for helping me!
On 22 Jun., 11:33, Tuna Toksoz <[email protected]> wrote:
> Those issues have also patches attached to them, so you can try applying
> those patches to your branch.
> If they are not there, of course...http://nhjira.koah.net/browse/NH-1394
>
> Tuna Toksöz
> Eternal sunshine of the open source mind.
>
> http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike
>
>
>
> On Mon, Jun 22, 2009 at 12:31 PM, Tuna Toksoz <[email protected]> wrote:
> > I guess,
>
> > SubqueryProjection
> > Projections
>
> > Revision: 3662
> > Author: fabiomaulo
> > Date: 8:09:20 AM, Friday, July 25, 2008
> > Message:
> > Fix NH-1393 and NH-1394 (by Tuna Toksoz)
> > ----
> > Added : /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Fixture.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/Projections.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/CountProjection.cs
> > Modified : /trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-2.0.csproj
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/Order.cs
> > Modified :
> > /trunk/nhibernate/src/NHibernate/Criterion/AggregateProjection.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/AvgProjection.cs
> > Modified :
> > /trunk/nhibernate/src/NHibernate.Test/ExpressionTest/Projection/ProjectionFixture.cs
> > Added : /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1393
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1393/Fixture.cs
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1393/Mappings.hbm.xml
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1393/Person.cs
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Mappings.hbm.xml
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1394/Person.cs
>
> > Revision: 3640
> > Author: ayenderahien
> > Date: 10:32:56 AM, Friday, July 18, 2008
> > Message:
> > NH-1359 - Applying patch from Will Shaver to create an IProjection from a
> > DetachedCriteria
> > ----
> > Modified : /trunk/nhibernate/src/NHibernate/Loader/Loader.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Dialect/MsSql2005Dialect.cs
> > Modified :
> > /trunk/nhibernate/src/NHibernate.Test/DialectTest/MsSql2005DialectFixture.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/Projections.cs
> > Modified : /trunk/nhibernate/src/NHibernate/SqlCommand/InFragment.cs
> > Modified : /trunk/nhibernate/src/NHibernate/NHibernate-2.0.csproj
> > Modified : /trunk/nhibernate/src/NHibernate/NHibernate-3.5.csproj
> > Modified : /trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-2.0.csproj
> > Modified : /trunk/nhibernate/src/NHibernate.Test/NHibernate.Test-3.5.csproj
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/SubqueryExpression.cs
> > Added :
> > /trunk/nhibernate/src/NHibernate/Criterion/SelectSubqueryExpression.cs
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/Subqueries.cs
> > Added : /trunk/nhibernate/src/NHibernate/Criterion/SubqueryProjection.cs
> > Modified :
> > /trunk/nhibernate/src/NHibernate/SqlCommand/SubselectClauseExtractor.cs
> > Modified :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1101/Domain.cs
> > Added : /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1359
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1359/Fixture.cs
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1359/Mappings.hbm.xml
> > Added :
> > /trunk/nhibernate/src/NHibernate.Test/NHSpecificTest/NH1359/Person.cs
>
> > Revision: 3637
> > Author: ayenderahien
> > Date: 8:59:41 AM, Friday, July 18, 2008
> > Message:
> > Applying patch from Will Shaver for NH-1291, Example.Create with anonymous
> > objects
> > ----
> > Modified : /trunk/nhibernate/src/NHibernate/Criterion/Example.cs
>
> > Those are taken from the SVN and if you create a diff file for those
> > revisions, I believe you are good to go.
>
> > Tuna Toksöz
> > Eternal sunshine of the open source mind.
>
> >http://devlicio.us/blogs/tuna_toksoz
> >http://tunatoksoz.com
> >http://twitter.com/tehlike
>
> > On Mon, Jun 22, 2009 at 12:28 PM, Smsgo <[email protected]> wrote:
>
> >> Which files shall I patch and where can they be found?- Skjul tekst i
> >> anførselstegn -
>
> - Vis tekst i anførselstegn -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
