开发者

CSV identity fields: nHibernate oddity or db design error?

开发者 https://www.devze.com 2023-01-08 00:53 出处:网络
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开发

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

精彩评论

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

关注公众号