Jump to content

Releation between entity types

Recommended Posts

We built our own framework where we can define different entity types. Each Entity Type has 1-n values. Then we allow different relation between entity types:
- Parent / Child
- Reference
- Link (m:n relation)


At first glance a parent/child relation is the same as a mandatory reference. But somehow it feels, it's not and I try to find the rules when to choose parent/child and when to choose reference.


Can someone point me to appropriate reading?




Share this post

Link to post

No. In my approach is I have only two tables in the SQL database: ENTITY and ENTITYVALUE. Basically each object has one record in ENTITY with general values (id, guid, ownerid, created, modified) and then it has one record for each value in ENTITYVALUE. Like this, the database is very generic and the meta information is in the code only.



Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now