Using Multiple Data-Models

7 posts, 0 answers
  1. Telerik Admin
    Telerik Admin avatar
    1679 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. Lucifer
    Lucifer 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. Zoran
    Zoran avatar
    534 posts

    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. Erik
    Erik 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. Zoran
    Zoran avatar
    534 posts

    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. Andrew
    Andrew avatar
    8 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. Kristian Nikolov
    Kristian Nikolov avatar
    206 posts

    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