Devart Forums

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?

Any Ideas, Guys?

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

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

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

Any Ideas, guys?

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

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

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

when can we download a fix?

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

when exactly the "upcoming" build will be available?

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/