Where to change connection string

15 posts, 0 answers
  1. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 23 Jul 2010 Link to this post

    I have a Capital Letter in my Connection string (typo) I need to fix

    I can change it manually in the .generated files, but if I UpdateFromDatabase it overwrites that (understandably so)

    Where's the right place to change it?
  2. Jordan
    Admin
    Jordan avatar
    547 posts

    Posted 26 Jul 2010 Link to this post

    Hello Steve,

    Unfortunately, there is currently no place in the UI where you can change the connection string settings.
    However, you can easily do that by opening the .rlinq file as an XML file and doing your changes at the beginning of the ModelSettings section.

    I hope this helps. Do not hesitate to write again if you have more questions.

    All the best,
    Jordan
    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. Gene
    Gene avatar
    64 posts
    Member since:
    Dec 2007

    Posted 22 Mar 2011 Link to this post

    Is there a place in the UI to replacethe connectionstring yet?
  5. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 23 Mar 2011 Link to this post

    Hi Gene,

    I am afraid that currently there is not a dialog that allows setting the connection string. Actually it is on our to-do list. We will consider this setting in the Model Settings dialog.
    Currently you should modify the connection string within the config file in order to achieve that goal.
    I am sorry for the inconvenience caused.

    Kind regards,
    Damyan Bogoev
    the Telerik team
  6. Gene
    Gene avatar
    64 posts
    Member since:
    Dec 2007

    Posted 14 Mar 2012 Link to this post

    Any update on this?
  7. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 15 Mar 2012 Link to this post

    Hello Gene,

    Unfortunately this feature request is not implemented yet. I am afraid that it is not on our to-do list for the next Q2 release of the product.
    You should modify the connection string in the configuration file.

    I am sorry for the inconvenience caused.


    All the best,
    Damyan Bogoev
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
  8. Gene
    Gene avatar
    64 posts
    Member since:
    Dec 2007

    Posted 15 Mar 2012 Link to this post

    Seems like a small change that would users could benfit from.  I spent a lot of time looking for how to change it.  What is the link to the PITS issue so we can vote on it and get this on the roadmap?


  9. Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 20 Mar 2012 Link to this post

    Hi Gene,

    I have created a PITS item for the development of this feature so that people can vote for it. It will be visible tomorrow morning.
    If any other questions arise, do not hesitate to contact us back.

    Greetings,
    Damyan Bogoev
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
  10. Gene
    Gene avatar
    64 posts
    Member since:
    Dec 2007

    Posted 21 Mar 2012 Link to this post

    here is the PITS item for those who would like to vote:
    http://www.telerik.com/support/pits.aspx#/details/Issue=10356
  11. MWW
    MWW avatar
    6 posts
    Member since:
    Oct 2012

    Posted 17 Oct 2012 Link to this post

    Hi, 

    Maybe better option is to allow change connection string programmatically- like some property ? In this case we can use something like (vb.net) Telerik.OpenAcces.Model.ConnectionString= My.Settings.ConnectionString. 

    I start my experience with Open Access so maybe there is some property (ex. actualConnectionString) which can be set up from runtime application ?


    Best Regards, 
    MWW
  12. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 22 Oct 2012 Link to this post

    Hi MWW,

    Setting the connection string through the UI is a feature that will be available with the next official release of Telerik OpenAccess ORM.

    Currently, you can change the connection string at runtime in two ways:
        - By adding a new connection string in the .config file and passing its name as a variable to the context constructor

    Adding a connection string in the .config file
    <connectionStrings>
        <add name="NorthwindConnection" connectionString="data source=.\sqlexpress;initial catalog=Northwind;integrated security=True" providerName="System.Data.SqlClient" />
        <add name="TestDBConnection" connectionString="data source=.\sqlexpress;initial catalog=TestDB;integrated security=True" providerName="System.Data.SqlClient" />
      </connectionStrings>

    Passing its name to the context constructor
    string northWindConnection = @"NorthwindConnection";

    using
    (EntitiesModel dbContext = new EntitiesModel(northWindConnection))
    {
            //Place the necessary code
    }

        - By assigning the connection string itself to a string variable and passing it to the context constructor
    string northWindConnection = @"data source=.\sqlexpress;initial catalog=Northwind;integrated security=True";
     
    using (EntitiesModel dbContext = new EntitiesModel(northWindConnection))
    {
            //Place the necessary code
    }

    If you have any additional questions, do not hesitate to get back to us.

    Regards,
    Doroteya
    the Telerik team
    Telerik OpenAccess ORM Meets ASP.NET Web API. Read more.
  13. MWW
    MWW avatar
    6 posts
    Member since:
    Oct 2012

    Posted 20 Aug 2013 Link to this post

    Hi, 

    On previous post you wrote that changing connection string is planned for next release. 

    I have question is this already done ? Where I can change connection string using UI ? 

    Best regards, 
    MWW
  14. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 23 Aug 2013 Link to this post

    Hi MWW,

    Excuse us for any inconvenience this might have caused you.

    Generally, setting the connection string through the UI is implemented as part of a feature that have not been included in any version of OpenAccess ORM.

    In fact, due to the development of other features, it is not scheduled for merging in the product and testing.

    I case you need additional assistance or experience issues, do not hesitate to get back to us.


    Regards,
    Doroteya
    Telerik
    OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.
  15. Youngjae
    Youngjae avatar
    5 posts
    Member since:
    Jul 2012

    Posted 03 May 2014 Link to this post

    Still not applied yet? It's surprisingly inconvinient. I'm huge fan of OpenAccess and Telerik products but it's not telerik-like.

    I opened rlinq file and found my connectionstring being copied from App.Config.
    It can be a serious problem when we distribute the rlinq file or openaccess file to public.

    Is it copied from App.Config at every saving or updating the rlinq file? If so, I need to remove the connectionstrings in rlinq file and share it to my partners.
  16. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 07 May 2014 Link to this post

    Hi Bapul,

    Thank you for the kind words and I am sorry for the inconvenience you experience.

    Indeed, the connection string utilized by a given domain model is copied inside its XML representation from the .config file during the saving operation, and this requires special attention when the .rlinq file is provided to a third party.

    Regarding the ability to edit the connection string through Visual Designer, currently, it is still unavailable and there was no additional development in this direction. There is, however, a feature request on our Ideas and Feedback portal about it, and your vote about it there will be appreciated.

    Thank you for you understanding. In case you have additional questions, do not hesitate to get back to us.


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