开发者

CSV identity fields: nHibernate oddity or db design error?

I've inherited a database and know an nHibernate engine was used on top of it.

Inside the database I see CSV values representing multiple identities instead of "proper" link tables being used f开发者_开发技巧or primary and foreign keys.

For example one tuple looks like this:

PersonID, int: 1

Name, varchar: John Smith

Edus, varchar: "76,5262,5261,5263,5264"

Events, varchar: "533,568,538,548,567,572"

Email, varchar: jsmith@example.com

I'm curious if this is a feature of Hibernate (possibly a way to configure it) or just questionable relational database design?


NHibernate does not directly support anything like that, so you'll have to look at the rest of the code.


Questionable database design.
This is called repeating groups.
It violates First Normal Form.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜