I have a situation where I have several many-to-many associations. In the upwards
of 12 to 15. Reading around I've seen that it's generally believed that many-to-many associations are not 'typical', yet they are the only way I have been able to create the associations appropriate for my case, so I'm not sure how to optimize any further.
Here is my basic scenario.
class Page {
IList<Tag> Tags { get; set; }
IList<Modification> Modifications { get; set; }
IList<Aspect> Aspects { get; set; }
}
This is one
of my 'core' classes, and coincidentally one
of my core tables. Virtually half
of the objects in my code can have an IList<Page>, and some
of them have IList<T> where T has its own IList<Page>.
As you can see, from an object oriented standpoint, this is not really a problem. But from a database standpoint this begins to introduce a lot
of junction tables.
So far it has worked fine for me, but I am wondering if anyone has any ideas on how I could improve on this structure. I've spent a long time thinking and in order to achieve the appropriate level
of association required, I cannot think
of any way to improve it. The only thing I have come up with is to make intermediate classes for each object that has an IList<Page>, but that doesn't really do anything that the HasManyToMany does not already do except introduce another class. It does not extend the functionality and, from what I can tell, it does not improve performance.
Any thoughts? I am also concerned about Primary Key limits in this scenario. Most everything needs to be able to have these properties, but the Pages cannot be unique to each object, because they are going to be frequently shared and joined between multiple objects.
All relationships are one-sided. (That is, a Page has no knowledge
of what owns it). Because
of this, I also have no Inverse() mapped HasManyToMany collections.
Also, I have read the similar question : Usage
of ORMs like NHibernate when there are many associations - performance
concerns
But it really did not answer my
concerns.
