Many-To-Many Class generation

nhellwig · Post by **nhellwig** » Tue 04 Jan 2011 08:45

Hi,

I'm using the Entity Framework 4 with RIA Services and Silverlight.
Since RIA Services doesn't support direct many-to-many associations, i've to include the joining table in my model and solve the many-to-many association through two one-to-many associations. This works fine so far.
The only problem happens when i try to add a new table from the database to the model. Everytime i do this, all joining tables are deleted from the model and transformed into direct associations (many-to-many) back again.
This is very annoying since i've to change them again and again everytime i update the model.
So is there a way to change the behaviour of creating associations, so that the model includes the joining table or is it possible to stop Entity Developer from transforming associations back to many-to-many ones?

Btw I'm using Entity Developer 3 with dotConnect 6.

Regards
Nikolai Hellwig
CHW Software GmbH

StanislavK · Post by **StanislavK** » Wed 05 Jan 2011 12:38

Thank you for your report, we will analyze the possibility of implementing such option. We will inform you about the results here.

StanislavK · Post by **StanislavK** » Fri 21 Jan 2011 16:46

We have implemented the possibility of disabling automatic detecting of many-to-many associations. To control this behaviour, please use the 'Detect ManyToMany Associations' model setting.

This feature will be available in the nearest build which we plan to release in about a week.

StanislavK · Post by **StanislavK** » Thu 27 Jan 2011 18:10

We have released the new 3.20.74 version of Entity Developer where it is possible to disable automatic resolving of many-to-many associations. In particular, the 3.20.74 version is included into the new builds of dotConnect for Oracle and dotConnect for MySQL.

They can be downloaded from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/
The trial versions are available at
http://www.devart.com/dotconnect/oracle/download.html
http://www.devart.com/dotconnect/mysql/download.html

For the detailed information about the fixes and improvements available in the new build, please refer to
http://www.devart.com/forums/viewtopic.php?t=20115 (dotConnect for Oracle)
http://www.devart.com/forums/viewtopic.php?t=20119 (dotConnect for MySQL)