Entity Developer (MySQL) and Reciprocal links issue

Discussion of open issues, suggestions and bugs regarding Entity Developer - ORM modeling and code generation tool
Post Reply
semenov
Posts: 7
Joined: Thu 10 Jun 2010 19:46

Entity Developer (MySQL) and Reciprocal links issue

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
Posts: 7
Joined: Thu 10 Jun 2010 19:46

Post by semenov » Fri 11 Jun 2010 03:08

Any Ideas, Guys?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 11 Jun 2010 14:58

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

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 7
Joined: Thu 10 Jun 2010 19:46

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
Posts: 7
Joined: Thu 10 Jun 2010 19:46

Post by semenov » Wed 16 Jun 2010 22:58

Any Ideas, guys?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 7
Joined: Thu 10 Jun 2010 19:46

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
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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
Posts: 7
Joined: Thu 10 Jun 2010 19:46

Post by semenov » Sun 04 Jul 2010 07:28

when can we download a fix?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Wed 07 Jul 2010 11:12

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

semenov
Posts: 7
Joined: Thu 10 Jun 2010 19:46

Post by semenov » Wed 07 Jul 2010 16:14

when exactly the "upcoming" build will be available?

AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

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/

Post Reply