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

mssql and oracle and others, at same time

1 Answer 51 Views
Databases and Data Types
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
bruno
Top achievements
Rank 1
bruno asked on 18 Feb 2011, 06:42 PM
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

1 Answer, 1 is accepted

Sort by
0
Alexander
Telerik team
answered on 24 Feb 2011, 08:24 AM
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!
Tags
Databases and Data Types
Asked by
bruno
Top achievements
Rank 1
Answers by
Alexander
Telerik team
Share this question
or