Does the openaccess data source support join tables?

4 posts, 0 answers
  1. Daniel
    Daniel avatar
    36 posts
    Member since:
    Apr 2009

    Posted 04 Apr 2011 Link to this post

    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.
  2. Damyan Bogoev
    Damyan Bogoev avatar
    581 posts

    Posted 07 Apr 2011 Link to this post

    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
  3. DevCraft banner
  4. Mulham
    Mulham avatar
    5 posts
    Member since:
    Mar 2007

    Posted 14 May 2011 Link to this post

    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.
  5. Damyan Bogoev
    Damyan Bogoev avatar
    581 posts

    Posted 16 May 2011 Link to this post

    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.
Back to Top