Ah! I didn't read it closely enough.
Agreed ... you cannot do that with QueryOver.
-----Original Message-----
From: CSharper
Sent: Tuesday, January 25, 2011 6:24 PM
To: nhusers
Subject: [nhusers] Re: nHibernate 3 - Problem with DateTime in Query
Hi,
no, he wants to use the .NET DateTime.Year property in a QueryOver
predicate and that's not possible.
I think it should be something like
.Where(x => x.Register >= new DateTime(year, 1, 1) && x.Register <
new DateTime(year + 1, 1, 1)
Regards.
On 24 Jan., 10:13, "Richard Brown \(gmail\)" <[email protected]>
wrote:
Hi Guilherme,
I think you'll need to explicitly join from Evento to Register. Something
like this might do it:
session.QueryOver<Evento>()
.JoinQueryOver(e => e.Register)
.Where(r => r.Year == year)
.List();
or
Register registerAlias = null;
session.QueryOver<Evento>()
.JoinAlias(e => e.Register, () => registerAlias)
.Where(() => registerAlias.Year == year)
.List();
http://nhforge.org/doc/nh/en/index.html#queryqueryover-associations
Regards,
Richard
-----Original Message-----
From: Guilherme Cardoso
Sent: Sunday, January 23, 2011 1:38 PM
To: nhusers
Subject: [nhusers] nHibernate 3 - Problem with DateTime in Query
Hi
I'm facing an issue using DateTime property Year. I'm receiving this
message error: NHibernate.QueryException : could not resolve property:
Register.Year of: Estudantino.Domain.Events
In Events class, i'm defining Register like this:
public virtual DateTime Registada { get; set; }
And i'm receiving the error from this query:
using (ISession session = NHibernateHelper.OpenSession())
{
return session.QueryOver<Evento>()
.Where(x => x.Register.Year == year)
.List();
}
I only get the error message if i use the property Year of Register.
What should i do to query using the year?
Thanks
--
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
athttp://groups.google.com/group/nhusers?hl=en.
--
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.
--
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.
