Hi guys Can anybody help me please?
On 22 דצמבר, 21:14, Ilya Kogan <[email protected]> wrote: > Hi all, > > I've started trying out Fluent HNibernate a week ago, and currently I > have three conundrums. I've been looking for solutions all over the > web with no success, and I'll be really happy if you can help. > The application accesses legacy tables that I cannot change, so some > of the relations are quite complicated and non-standard. > > 1. A Ticks column > > There's an Oracle number column that represents the number of ticks in > a date. I'd like to have a DateTime property in my model class: > > public virtual DateTime Time { get; set; } > > and map it to the ticks column. I tried to use > > .CustomType(typeof(long)) > > but it didn't work, NHibernate threw a System.InvalidCastException (my > guess is that there was a problem casting between an Int64 and a > DateTime). > > Must I implement an IUserType, or is there a simpler way? > > 2. A custom 'ON' clause > > There's an Intervals table with columns START_TIME and END_TIME. > There's an Events table with column TIME. > In the mapping I need to create a relation that would produce the > following JOIN: > > Events JOIN Intervals > ON Events.TIME >= Intervals.START_TIME > AND Events.TIME <= Intervals.END_TIME > > I've seen someone mention named queries, but I have no idea how to use > a named query as an 'ON' clause. > Is there a way to make such a relation? -- 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.
