Devart Forums

We are not being able to use my.settings or a connection string in the app.config file when we define a mysqlconnectionstring using the GUI.
Is there a way to do that, or a workaround ?

We are using MySQL Direct.NET Version 3.50.11.0


Thanks in advance ..


Best Regards,

Alberto Abudara.

Please describe in detail what exactly you need or what is the problem.

I have the connectionstring in the app.config file for all the application.

We have a .NET component, where we have a dataadapter and dataset we include in the designer.
It requires us to define the connection and creates a mysqlconnection object, but it has the connection string in it, we want the mysqlconnection object obtain the connectionstring from the config file.
We can do it by hand modifying the designer, but if we make changes to the dataadapter, we have to change again by hand everything !!

I hope is more clear the problem now.

Regards,
Alberto.

Unfortunately, it is not possible to use connection strings from app.config in MySqlDataAdapter in design-time.

Does this mean that you can't use the MySQLDirect design surface components at all without hard-coding the connection string? Given that hard-coding connection strings is one of the worst things you can do as a developer, do you recommend avoiding the use of the design surface?

Are you able to use the my.settings rather than app.config?

We will consider your suggestions.
We are planning to add app.config support into connection string editor.
Also we are going enhance ConnectionString code serialization.