nhibernate activerecord lazy collection with custom query

views:

answers:

nhibernate activerecord lazy collection with custom query

What i'm trying to accomplish, is having a temporal soft delete table.

table Project(ID int)

table ProjectActual(ProjectID int, IsActual bit, ActualAt datetime)

Now is it possible to map a collection of actual projects, where project is actual when there is no record in ProjectActual.ProjectID = ID, or the last record sorted by ActualAt descending has IsActual set to 1 (true)?

related questions

IQuery NHibernate - does it HAVE to be a list?

(N)Hibernate - is it possible to dynamically map multiple tables to the one class

How can I map a list of strings to my entity using NHibernate?

Best practices for querying with NHibernate

NHibernate ISession Flush: Where and when to use it, and why?

IList.Cast<typeof(T)>() returns error, syntax looks ok

NHibernate Generators

101 tutorial for setting up nhibernate?

NHibernate Session.Flush() Sending Update Queries When No Update Has Occurred

NHibernate SetTimeout on ICriteria

Best way to manage session in NHibernate?

Has anyone moved to NHibernate 2.0 in a production environment?

NHIbernate: Difference between Restriction.In and Restriction.InG

NHibernate and Oracle connect through Windows Authenication

Is it possible to use nHibernate with Paradox database?

NHibernate 1.2 to 2.0 migration

NHibernate vs LINQ to SQL

Windows Service Increasing CPU Consumption

(N)Hibernate Auto-Join

MSTest and NHibernate

SQL 2008 Dialect Support for NHibernate

ADO.NET Entity vs NHibernate

Data Auditing in NHibernate and SqlServer

Best way to model Many-To-One Relationships in NHibernate When Dealing With a Legacy DB?

Subsonic Vs NHibernate

ansaurus

tags:

views:

answers:

nhibernate activerecord lazy collection with custom query

related questions