Entity Developer (MySQL) and Reciprocal links issue

semenov · Post by **semenov** » Thu 10 Jun 2010 20:05

Hi,

I have the following mysql ER Diagram:
http://screencast.com/t/M2ZlYjVkZTA

Here is how I'm making my EF model:

the User class will be inherited (Concrete Table) from Registry class
http://screencast.com/t/NzNiMTll

after that I'm getting the reciprocal links (User.userID -> Registry.CreatedBy, User.userID -> Registry.DeletedBy, User.userID->Registry.deletedBy) hightlighted by red color as shown below:

http://screencast.com/t/M2RlYjg1YjAt

the text of error is this:

1 Properties referred by the Principal Role User must be exactly identical to the key of the EntityType DataSourceModel.User referred to by the Principal Role in the relationship constraint for Relationship DataSourceModel.User_Registry. Make sure all the key properties are specified in the Principal Role. DataSourceModel1.edml

if I click on any "red" connection I'm getting this dialog:
http://screencast.com/t/NTI3OTJkM

after that I'm going to User->Mapping and change userID to be mapped to RegistryID column and then erasing the userID column from User class since it is no longer needed. AFter that I'm getting error, because now connections aren't mapped to anything, and I can't select a mapping at all.

see what I'm doing in a video (jing in flash):
http://screencast.com/t/ODY0YTQyM2Yt

I suppose to see here the registryID (since it is inherited from Registry table) and I don't see it
http://screencast.com/t/NzI5NDNlOW

in EF 4.0 (VS 2010 and 2008) and earlier version of MS SQL EF Designer I was able to select RegistryID and make such mapping.

If I go and modify the EDML file of Devart Designer - it crashes, after I try to reload the model

any Ideas?

semenov · Post by **semenov** » Fri 11 Jun 2010 03:08

Any Ideas, Guys?

AndreyR · Post by **AndreyR** » Fri 11 Jun 2010 14:58

We are investigating the situation. I will let you know about the results.

AndreyR · Post by **AndreyR** » Mon 14 Jun 2010 14:58

Could you please send us the script of the objects taking part in the inheritance? This will speed up our investigation.

semenov · Post by **semenov** » Tue 15 Jun 2010 18:45

What do you mean by scripts? DDL?

I can send you DDL of the database + EF MOdel I have created if that helps.

DDL file is here: http://drop.io/xttqfx0
ER Diagram is here: http://screencast.com/t/ZjhmYjI5MzMt

that's the model that I have created:
http://screencast.com/t/Yzc5M2Iw

to solve reciprocal issue. If you need original ED file - please let me know

semenov · Post by **semenov** » Wed 16 Jun 2010 22:58

Any Ideas, guys?

AndreyR · Post by **AndreyR** » Thu 17 Jun 2010 12:49

Our investigation is in progress. I will post here about the results of our investigation.

semenov · Post by **semenov** » Wed 30 Jun 2010 00:49

any news so far? If we go and modify the files generated (the way MS EF does their files) it works. But it's nasty - I don't want to do that everytime - it's waste of time. So designer doesn't allow me to do that MS EF allows easily through VS

We need to select the FW this week and are looking between your solution and LightSpeed ORM. If you can't make it soon - please ping me and we will go different way

AndreyR · Post by **AndreyR** » Thu 01 Jul 2010 13:22

We have fixed the problem, look forward to the nearest build of dotConnect for MySQL.

semenov · Post by **semenov** » Sun 04 Jul 2010 07:28

when can we download a fix?

AndreyR · Post by **AndreyR** » Wed 07 Jul 2010 11:12

We have fixed this problem. The upcoming build will contain this fix.

semenov · Post by **semenov** » Wed 07 Jul 2010 16:14

when exactly the "upcoming" build will be available?

AndreyR · Post by **AndreyR** » Wed 07 Jul 2010 16:41

We have released the 5.80.146 build of dotConnect for MySQL. It can be downloaded here (the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/