You're' very welcome snickers :-) Actually, EF4 is not an option for us either until we have exhausted all options with NH. Frankly, I suspect EF4 will have serious issues with bi-temp databases as well, but if all else fails we will certainly look into hooking into EF4 at some level to achieve out goals.
But I would be interested in hearing the NH community's take one mapping (bi-)temp databases. In particlular we are interested in mapping a particular type of database called Asserted Versioning Tables, as outlined here: http://mindfuldata.com/TemporalDataManagement/tempdm-pdf/Asserted%20Versioning%202008-06.pdf Basically with this approach you end up with several versions of an entity (one row per version), and these version share the same business key. Only when you consider the temporal aspect of the entity do you get a single row/version. This means traditional PK/FK realtionships are off. I have noticed that there are several references out there of people rolling their own temporal databases, using sprocs, filters etc, But the method outlined in the link above seem to be based on a solid foundation, and consider most aspects of "bi-temporality". Perhaps it could provide a more-or-less standardized way of tackling time in our entity models? So some questions to the community: Has anyone attempted to map such a beast (or something similar)? Is NH up to the task of handling this? What would need to change in order for NH to handle this? Who should we contact (contract with) if we wished to have someone help us develop this kind of support in NH? -- Thor A. Johansen R&D Manager Oppad AS On 23 Mar, 16:48, snicker <[email protected]> wrote: [snip] > > EF4 is not an option in my case because I will not be using MSSQL. > > Thank you for your valuable input Thora. > -- 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.
