Class DatabaseUtil.SqlQueryBuilder

Namespace: Workspace.XBR.Xperiflow.Utilities.Database

Assembly: Xperiflow.dll

Declaration

public class DatabaseUtil.SqlQueryBuilder

Methods

AddLine(string)

Declaration

public void AddLine(string newLine)

Parameters

Type	Name
System.String	newLine

AddLine(string, params object[])

Declaration

public void AddLine(string newLine, params object[] @params)

Parameters

Type	Name
System.String	newLine
System.Object[]	params

AddParameter(string, object)

Declaration

public void AddParameter(string paramName, object paramValue)

Parameters

Type	Name
System.String	paramName
System.Object	paramValue

CreateInClause(object)

Declaration

public string CreateInClause(object itemList)

Returns

System.String

Parameters

Type	Name
System.Object	itemList

GetDataTable()

Declaration

public DataTable GetDataTable()

Returns

System.Data.DataTable

GetDataTable(string, DbLocation, bool, bool)

Declaration

public DataTable GetDataTable(string tableName, DbLocation dbLocation, bool useCommandTimeoutLarge, bool includePrimaryKeyInfo)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.Boolean	useCommandTimeoutLarge
System.Boolean	includePrimaryKeyInfo

GetDataTable(string, DbLocation, string, bool, bool)

Declaration

public DataTable GetDataTable(string tableName, DbLocation dbLocation, string externalConnectionName, bool useCommandTimeoutLarge, bool includePrimaryKeyInfo)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.String	externalConnectionName
System.Boolean	useCommandTimeoutLarge
System.Boolean	includePrimaryKeyInfo

ExecuteAndReturnDataTable()

Declaration

public DataTable ExecuteAndReturnDataTable()

Returns

System.Data.DataTable

ExecuteAndReturnDataTable(string)

Declaration

public DataTable ExecuteAndReturnDataTable(string tableName)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName

ExecuteAndReturnDataTable(string, DbLocation, bool)

Declaration

public DataTable ExecuteAndReturnDataTable(string tableName, DbLocation dbLocation, bool useCommandTimeoutLarge)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.Boolean	useCommandTimeoutLarge

ExecuteAndReturnDataTable(string, DbLocation, string, bool)

Declaration

public DataTable ExecuteAndReturnDataTable(string tableName, DbLocation dbLocation, string externalConnectionName, bool useCommandTimeoutLarge)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.String	externalConnectionName
System.Boolean	useCommandTimeoutLarge

ExecuteAndReturnDataReader()

Declaration

public DataTable ExecuteAndReturnDataReader()

Returns

System.Data.DataTable

ExecuteAndReturnDataReader(string)

Declaration

public DataTable ExecuteAndReturnDataReader(string tableName)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName

ExecuteAndReturnDataReader(string, DbLocation, bool)

Declaration

public DataTable ExecuteAndReturnDataReader(string tableName, DbLocation dbLocation, bool useCommandTimeoutLarge)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.Boolean	useCommandTimeoutLarge

ExecuteAndReturnDataReader(string, DbLocation, string, bool)

Declaration

public DataTable ExecuteAndReturnDataReader(string tableName, DbLocation dbLocation, string externalConnectionName, bool useCommandTimeoutLarge)

Returns

System.Data.DataTable

Parameters

Type	Name
System.String	tableName
OneStream.Shared.Wcf.DbLocation	dbLocation
System.String	externalConnectionName
System.Boolean	useCommandTimeoutLarge

ExecuteActionQuery()

Declaration

public long ExecuteActionQuery()

Returns

System.Int64

ExecuteActionQuery(DbLocation, bool)

Declaration

public long ExecuteActionQuery(DbLocation dbLocation, bool useCommandTimeoutLarge)

Returns

System.Int64

Parameters

Type	Name
OneStream.Shared.Wcf.DbLocation	dbLocation
System.Boolean	useCommandTimeoutLarge

ExecuteActionQuery(DbLocation, string, bool)

Declaration

public long ExecuteActionQuery(DbLocation dbLocation, string externalConnectionName, bool useCommandTimeoutLarge)

Returns

System.Int64

Parameters

Type	Name
OneStream.Shared.Wcf.DbLocation	dbLocation
System.String	externalConnectionName
System.Boolean	useCommandTimeoutLarge

Reset()

Declaration

public void Reset()

QueryString()

Declaration

public string QueryString()

Returns

System.String

WriteQueryToLog()

Declaration

public void WriteQueryToLog()

Inherited Members

• System.Object.Equals(System.Object)
• System.Object.Equals(System.Object,System.Object)
• System.Object.GetHashCode
• System.Object.GetType
• System.Object.MemberwiseClone
• System.Object.ReferenceEquals(System.Object,System.Object)
• System.Object.ToString