Hello users,

before diving into studing details I need to check that NHibernate can handle my scenario. My (given) database schema has two specifities:

1) primary and foreign keys, EUIDs, are composites consisting from smallint and int IDENTITY. The smallint part is database id and it guarantees that whole EUID is unique over several replicated databases, clients know this one and mentions it explicitly in all INSERTs. After insert client using SCOPE_IDENTITY() retrives database server assigned int part. Most FKs do not allow NULLs.

2) there is no record ever dropped from database (excluding archiving service) but instead all 'deleted' records are marked by setting [deleted] bit field. Ideally Delete() method should toggle this flag and Find(), List() methods exclude objects for [deleted] records.

Last but not least data model is quite big, >600 tables, crashing most generators or compiler while compiling it, ... have not checked Hibernate failure equivalent, yet :-).

Are above specifities mappable and long term manageable by NHibernate?

Thank you
Cc.