Where to change connection string

[sitefinitysteve]

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?

[Jordan]

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

[Gene]

Is there a place in the UI to replacethe connectionstring yet?

[Damyan Bogoev]

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

[Gene]

Any update on this?

[Damyan Bogoev]

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

[Gene]

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?

[Damyan Bogoev]

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

[Gene]

here is the PITS item for those who would like to vote:
http://www.telerik.com/support/pits.aspx#/details/Issue=10356

[MWW]

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

[Doroteya]

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

[MWW]

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

[Doroteya]

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

[Youngjae]

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.

[Doroteya]

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