This is a migrated thread and some comments may be shown as answers.

Failure converting EF model?

14 Answers 74 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Kendall Bennett
Top achievements
Rank 2
Kendall Bennett asked on 25 Apr 2011, 10:28 PM
Hi,

I am evaluating OpenAccess ORM using the trial edition, and I am trying to convert my EF 4.1 data model to Open Access, so I can get started quickly with evaluating it and comparing it to the Microsoft solution. However I keep getting an error during the conversion process:

Conversion Failed
The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at Telerik.OpenAccess.Converters.Common.OpenAccessMetadataRules.ConvertToOAClrType(MetaColumn oaColumn, Type type, Boolean isNullable)
at Telerik.OpenAccess.EFConverter.Engine.ConversionEngine.PopulatePrimitiveTypeMembers(MetaPersistentType oaType)
at Telerik.OpenAccess.EFConverter.Engine.ConversionEngine.ConvertPersistentTypes()
at Telerik.OpenAccess.Converters.Common.ConversionEngineBase.ConvertToOA(ConversionSettingsBase conversionSettings)
at Telerik.OpenAccess.Converters.Common.ConversionEngineManagerBase.Convert(ConversionSettingsBase conversionSettings)

Is this a known problem? Is there any way to work around this issue?

14 Answers, 1 is accepted

Sort by
0
Kendall Bennett
Top achievements
Rank 2
answered on 26 Apr 2011, 07:09 PM
Any help with this question? I am really stuck at the moment as I wish to fully evaluate OpenAccess, but can't get this model converted.
0
Pencho
Telerik team
answered on 27 Apr 2011, 05:09 PM
Hello Kendall Bennett,

It seems that one of your tables contains a column of a database type that is not supported by the EF converter. Unfortunately, we are unable to reproduce the error. Is it possible to send us a sample project with your EF model, in order to investigate the problem? We are looking forward for your reply.

Kind regards,
Pencho
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Kendall Bennett
Top achievements
Rank 2
answered on 27 Apr 2011, 05:36 PM
I opened a support ticket when I posted here and I attached my EDMX model to the ticket yesterday so if you can take a look that would be great.
0
Pencho
Telerik team
answered on 28 Apr 2011, 05:05 PM
Hi Kendall Bennett,

Please find my answer in the support thread (#417715).

Best wishes,
Pencho
the Telerik team
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
0
Kendall Bennett
Top achievements
Rank 2
answered on 28 Apr 2011, 06:12 PM
Thank you very much!
0
Kendall Bennett
Top achievements
Rank 2
answered on 25 Jun 2011, 04:55 AM
Since this is not yet fixed, and we ended up moving further along using Entity Framework, we now have our database fully mapped and I need to get it converted over so I can compare Telerik head to head with Entity Framework. I posted our final model to the support thread, if someone can take a look at it and convert the model again for me?
0
Pencho
Telerik team
answered on 28 Jun 2011, 01:41 PM
Hi Kendall Bennett,

Please find my answer in the support thread (#417715).

Regards,
Pencho
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
0
Kendall Bennett
Top achievements
Rank 2
answered on 29 Jun 2011, 02:49 AM
Thanks you for the updated model in the support ticket. I have sent you a new model to convert, and removed the MEST and complext properties from it since those are not supported. Hopefully this one will convert cleanly and I can run my tests :)
0
Kendall Bennett
Top achievements
Rank 2
answered on 09 Jul 2011, 12:50 AM
One more time I have send you a final model to convert. I look forward to the Q2 release so I won't need to bug you about this, but I desperately need this model converted as we are done with our conversion to Entity Framework, and the performance is terrible. So I need to get cracking on moving to OpenAccess ASAP.
0
Pencho
Telerik team
answered on 11 Jul 2011, 07:46 PM
Hi Kendall Bennett,

Please find my answer in the support thread (#441807).

Greetings,
Pencho
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

0
Kendall Bennett
Top achievements
Rank 2
answered on 17 Jul 2011, 03:52 AM
I finally have this going, but there appears to be a lot broken in the conversion from Entity Framework to an RLINQ file, at least in terms of supporting MySQL. The biggest issue I ran into was related to conversion of associations. Even though they appears to have converted over properly, the model did not validate correctly at all because the associations were not properly bound to the appropriate foreign keys in the entities. I had to do that manually using the error dialog box that pops up, and fix all the associations. Now that I have that done, my model is working, but it took a lot of work.
0
Pencho
Telerik team
answered on 18 Jul 2011, 07:49 PM
Hello Kendall Bennett,

Thank you for reporting this issue, we were able to reproduce it. It seems that the problem occurs during the conversion of one-to-one associations, which currently are not supported by OpenAccess. Just for now, you will need to use the Validation Error dialog (as you've already done). We are sorry for the inconvenience caused.

Regards,
Pencho
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

0
Kendall Bennett
Top achievements
Rank 2
answered on 18 Jul 2011, 08:20 PM
Yes, it does appear to be related to one-to-one associations and I managed to fix them all up manually.

I implemented one to one associations in my code by using two one-to-many associations and left off the end points on both ends if I wanted it to have reference objects on each end. Sometimes I just left of the collection end if the other end had no value being there.
0
Pencho
Telerik team
answered on 20 Jul 2011, 04:34 PM
Hello Kendall Bennett,

We are happy that you have managed to solve the problem.
Please do not hesitate to contact us back should anything else pops up.

Kind regards,
Pencho
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Tags
General Discussions
Asked by
Kendall Bennett
Top achievements
Rank 2
Answers by
Kendall Bennett
Top achievements
Rank 2
Pencho
Telerik team
Share this question
or