Run sqlcmd and query database from script

[Zee357]

Has anyone executed sqlcmd (command-line) utility from a Ranorex automation script and fired a T-SQL script to query the database?

I need to do this in a web application testing scenario that needs to both run SELECTs as well as INSERTs and DELETEs against the back-end SQL Server database.

Thanks.

[Support Team]

Hello Zee357,

Since Ranorex is based on C# you could write your own usercode function in order to execute a SQL command, for example: how-to-execute-an-sql-script-file-using-c-sharp

Sincerely,
Robert