Access datasource properties from code

[Alex Rak]

Hi,

I've seen the example of how to access SQL database from the code, which would work perfectly fine. One thing I don't like thought, is defining the connection string in the code. I'd rather have access to a connection string property of my datasource which is defined in the project. Is this currently possible?

Regards.

[Byron]

Hello Alex Rak,

Thanks for trying Test Studio. Using Test Studio Standalone, you can define a connection string property when binding your SQL data source. Afterward, you can access the database through the Data object in code. 

Kind regards,
Byron
the Telerik team

[Alex Rak]

Hi, Byron, thanks for getting back on this.

You're right, I could access the Data object to read the data. What I need is a direct call towards the database. Let's say I want to make a database insert from withing the coded step, or call a stored procedure with custom parameters. There's no way to do that other than creating my proper database connection in the coded step. What I don't want is to manage my connection strings in the code. I would rather access the connection string of a DataSource that's already defined in my project. Is this possible?

Regards.

[Byron]

Hello Alex,

There is a way to store and access the connection string outside the coded step using the Visual Studio Plugin: overriding the app.config file, which contains run-time configuration settings for the Visual Studio project, including connection strings. Our user guide discusses the code necessary to find, open, read, and parse this file.

Regards,
Byron
the Telerik team