Hello,
i'm working on a multi language approach using NHibernate, this
approach use two table name "TextRef" and "TextRefItem" to keep multi
language data of every entity.
TextRef
===========
TextId : int
TextRefItem
===========
TextRefId : int
TextId : int
LangId : int
Text : nvarchar(max)
now, for example i may have a Product table which has two textual
field and they reference TextRef table
Product
===========
ProductId : int
TitleRef : int
DescriptionRef : int
Price : currency
i implement this approach using many-to-ones. so in this example i
have two many-to-one from Product to TextRef table, but the problem is
it's not really a many-to-one relationship. so it cause some problems,
for example it's not possible to cascade deletion of a TextRef when
the owner entity get removed.
i thinks it's not a one-to-one relationship too, because every table
which has multilanguage data would have a relation to TextRef table
so first of all i want to know is there any standard for these kind of
relations ? and how should i introduce them to NHibernate ?
Thanks in advance
--
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.
