views:

36

answers:

0

Hi!

Our legacy app there is this interesting feature that Order master table is splitted into two tables

Order_Master and Order_Master_History. In Order_Master table there are all today orders and Order_Master_History table will have all historical info.

The new integration app I write would need to benefit on those two tables as union query. But how should I map the nhibernate OrderMaster entity so I could execute additional HQL queries against this mapping?