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

Does the openaccess data source support join tables?

3 Answers 191 Views
Getting Started
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Daniel
Top achievements
Rank 2
Daniel asked on 05 Apr 2011, 02:09 AM
I have followed the examples using the open access dataadapter and am able to do crud on 1 table, how do I do this on a
join table without writing code.  For my purpose the OA adapter allows rapid development with little or as it handle all the crud against
the generate .rling class. but I cant seem to find an example to query and update without writing a linq query or update statement in code behind.  Thanks for your help.

3 Answers, 1 is accepted

Sort by
0
Damyan Bogoev
Telerik team
answered on 07 Apr 2011, 05:14 PM
Hello Daniel,

Actually you could map a join table to a persistent type and use it as a real entity. In order to achieve that goal you should do the following steps:
- Select the join table under the Model Schema Explorer;
- Press F4 to open the Properties grid;
- Set the IsJoinTable setting to True;
- Right-click on the join table and select Create a Domain Class;
- Save the diagram;
Hope that helps.

Kind regards,
Damyan Bogoev
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
Mulham
Top achievements
Rank 2
answered on 14 May 2011, 07:50 PM
Hello Damyan,
I was trying the steps that you outlined here, but once I set the "IsJoinTable" property to true, then the "Create a Domain Class" option disappears from the context menu. am I missing something here?

Mulham Swaidan.
0
Damyan Bogoev
Telerik team
answered on 16 May 2011, 04:51 PM
Hello Mulham,

Firstly I want to apologize for the inconsistent answer in my previous post.
Actually you should set the IsJoinTable to False in order to achieve that goal.
Hope that helps.

Best wishes,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
Tags
Getting Started
Asked by
Daniel
Top achievements
Rank 2
Answers by
Damyan Bogoev
Telerik team
Mulham
Top achievements
Rank 2
Share this question
or