mssql and oracle and others, at same time

2 posts, 0 answers
  1. bruno
    bruno avatar
    15 posts
    Member since:
    Sep 2010

    Posted 18 Feb 2011 Link to this post

    Hi,

    I am using Telerik_OpenAccess_ORM_2010_3_1125_dev.zip.
    What i want is, depending on my clients data base, i want to communicate with mssql, oracle, mysql or postgreSQL. They have the same tables.
    Is there any way to do this using the same Entity Diagram?
    I don't want to make 4 Entity Diagrams and repeat the some code 4 times.

    Best Regards,

    Bruno Almeida
  2. Alexander
    Admin
    Alexander avatar
    727 posts

    Posted 24 Feb 2011 Link to this post

    Hi bruno,

    I will share here my answer from the support ticket you sent us on the same topic, maybe it will be helpful to someone else as well:

    The main problem in such cases is that currently a property of a persistent class can be mapped to only one column definition. Having this in mind, if the columns mapped to this property from the different backends differ in any way (different name, type or length), we will not be able to store the column information specific for each backend but for only one of them. We have planned to avoid this limitation by providing functionality to store database specific information for multiple backends in one model but it is not guaranteed that this will happen for the upcoming Q1 release.

    However, if you use entirely forward mapping, without specifying any relational parts in the model (tables/columns) and let OpenAccess use its default mapping mechanism, the model would work with any backend. The drawback is that you will not have control over the table definitions as they have to be produced by OpenAccess during runtime.

    Best wishes,
    Alexander
    the Telerik team
    Registration for Q1 2011 What’s New Webinar Week is now open. Mark your calendar for the week starting March 21st and book your seat for a walk through all the exciting stuff we ship with the new release!
  3. DevCraft banner
Back to Top