tags:

views:

40

answers:

0

I have a scenario where I want to persist document info record to a table specific to the typo of document, rather than a generic table for all records.

For example, records for Invoices will be stored in dbo.Doc_1000 and records for Receipts will be stored in dbo.Doc_2000 where 1000 and 2000 are id autogenerate and store in well-known table (dbo.TypeOfDoc.

Furthermore each dbo.Doc.xxx table have a group of system column (always the same) and could have a group of dynamic column (metadata).

Tables dbo.Doc.xxx and eventually dynamic column are clearly created at runtime.

If this is possible with NHibernate???

Thanks.