SqlHelperExecuteSqlCommand Method (String, String, String)

Framework to automate tests using Selenium WebDriver

Method is used for execution SQL query (select) and reading each row from column.

Namespace: Ocaramba.Helpers
Assembly: Ocaramba (in Ocaramba.dll) Version: 3.3.1

Syntax

public static ICollection<string> ExecuteSqlCommand(
	string command,
	string connectionString,
	string column
)

Parameters

command: Type: SystemString
SQL query.
connectionString: Type: SystemString
Server, user, pass.
column: Type: SystemString
Name of column.

Return Value

Type: ICollectionString
Collection of each row existed in column.

Examples

How to use it:

Copy

var connectionString = "User ID=sqluser;Password=sqluserpassword;server=servername;";
const string ColumnName = "AccountNumber";
const string SqlQuery = "SELECT  AccountNumber as " + ColumnName + " FROM [AdventureWorks].[Sales].[Customer] where [CustomerID] in (1, 2)";
var result = SqlHelper.ExecuteSqlCommand(SqlQuery, connectionString, ColumnName);

Reference

SqlHelper Class

ExecuteSqlCommand Overload

Ocaramba.Helpers Namespace

SqlHelperAddLanguageSpecificTextSet("LSTEF13E57_0?cpp=::|nu=.");ExecuteSqlCommand Method (String, String, String)

Parameters

Return Value

Reference

SqlHelperExecuteSqlCommand Method (String, String, String)