SqlHelperExecuteSqlCommand(String, String, String) Method

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: 4.2.2

Syntax

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

Request Example

Parameters

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

Return Value

ICollectionString
Collection of each row existed in column.

Example

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