Failure converting EF model?

15 posts, 0 answers
  1. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 25 Apr 2011 Link to this post

    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?
  2. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 26 Apr 2011 Link to this post

    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.
  3. DevCraft banner
  4. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 27 Apr 2011 Link to this post

    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
  5. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 27 Apr 2011 Link to this post

    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.
  6. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 28 Apr 2011 Link to this post

    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
  7. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 28 Apr 2011 Link to this post

    Thank you very much!
  8. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 24 Jun 2011 Link to this post

    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?
  9. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 28 Jun 2011 Link to this post

    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.
  10. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 28 Jun 2011 Link to this post

    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 :)
  11. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 08 Jul 2011 Link to this post

    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.
  12. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 11 Jul 2011 Link to this post

    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!

  13. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 16 Jul 2011 Link to this post

    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.
  14. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 18 Jul 2011 Link to this post

    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!

  15. Kendall Bennett
    Kendall Bennett avatar
    80 posts
    Member since:
    Feb 2010

    Posted 18 Jul 2011 Link to this post

    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.
  16. Pencho
    Admin
    Pencho avatar
    22 posts

    Posted 20 Jul 2011 Link to this post

    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!

Back to Top
DevCraft banner