Using Multiple Data-Models

Thread is closed for posting
7 posts, 0 answers
  1. 63F75A2C-1F16-4AED-AFE8-B1BBD57646AD
    63F75A2C-1F16-4AED-AFE8-B1BBD57646AD avatar
    1572 posts
    Member since:
    Oct 2004

    Posted 10 Jan 2009 Link to this post


    .NET version

    Visual Studio version

    programming language


    The attached project is a sample application presenting the use of different data-models attached to different databases, described step-by-step in the related Knowledge-Base article.
  2. 3E12C1F4-C786-45DA-8280-BCF26350671A
    3E12C1F4-C786-45DA-8280-BCF26350671A avatar
    23 posts
    Member since:
    Oct 2003

    Posted 11 Apr 2010 Link to this post

    Hi, there is no link to the related Knowledge-Base article?
  3. 8920710C-BE97-4422-A231-83C12EBD9387
    8920710C-BE97-4422-A231-83C12EBD9387 avatar
    534 posts
    Member since:
    Jan 2015

    Posted 14 Apr 2010 Link to this post

    Hi Lucifer,

     Thanks for the report. We just updated the glitch.

    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.
  4. C3B016CF-D7C3-4D97-A541-50335AE3A574
    C3B016CF-D7C3-4D97-A541-50335AE3A574 avatar
    314 posts
    Member since:
    Feb 2008

    Posted 20 Sep 2011 Link to this post


    and how should/could we do this with the current ORM?

  5. 8920710C-BE97-4422-A231-83C12EBD9387
    8920710C-BE97-4422-A231-83C12EBD9387 avatar
    534 posts
    Member since:
    Jan 2015

    Posted 22 Sep 2011 Link to this post

    Hi Erik,

     At the moment this is a missing functionality in the new Visual Designer workflow and is a feature that we will be adding in the near future. Right now you can not use multiple backends out-of-the-box with a model defined in the Visual Designer. This functionality only works if your model is defined in a Model-First scenario and there is  absolutely no explicit database mapping defined. In this case you can only change the connection string and the Update Database From Model wizard will generate the correct SQL script for the desired backend. However this is definitely a feature that has high priority on our todo list and we will make sure there is smooth user experience for projects that are intended to use multiple backends or to be migrated from one backend to another.

    Kind regards,
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  6. 8C91CAEA-AD4C-4849-BDFE-2AE478CD64FB
    8C91CAEA-AD4C-4849-BDFE-2AE478CD64FB avatar
    9 posts
    Member since:
    Mar 2012

    Posted 30 May 2014 Link to this post

    Apologies in advance for bumping an old thread but I'd just like to know from a Telerik resource if functionality was ever added to Data Access to support multiple backends out-of-the-box with the Visual Designer.  We have projects that are required to support both SQL Server and Oracle and our current approach of programmatically modifying the metadata at run-time is very inefficient.

    I found the following in the documentation but it looks like it's specific to the Fluent API mapping.

    How to: Change the Backend
  7. D2394917-F52F-4BE9-A25A-3261F11435D1
    D2394917-F52F-4BE9-A25A-3261F11435D1 avatar
    206 posts
    Member since:
    Sep 2016

    Posted 04 Jun 2014 Link to this post

    Hello Andrew,

    Models using the visual designer (Domain Models) do offer support for backend independent mapping.

    In the Model Schema Explorer you can open the Properties windows for reach table column. In the column properties there is an AdoType property - it specifies the type of the column in a backend independent manner. You can try and see if this approach would work for your scenario - clear the value of the SqlType property and only specify the value of the AdoType property. Please find attached a text file which describes the values for the AdoType property.

    I hope this helps. If you have additional questions, do not hesitate to get back to us in our forums or via the Ticketing System.

    Kristian Nikolov
    OpenAccess ORM is now Telerik Data Access. For more information on the new names, please, check out the Telerik Product Map.
Back to Top

This Code Library is part of the product documentation and subject to the respective product license agreement.