Click or drag to resize

DBDriverBaseExecuteSqlString Method

Executes the string specified as one or more queries and returns the results in a list of sqlexecutionresults, one per query executed.

Namespace:  SD.LLBLGen.Pro.DBDriverCore
Assembly:  SD.LLBLGen.Pro.DBDriverCore (in SD.LLBLGen.Pro.DBDriverCore.dll) Version: 5.8.0.0 (5.8.21.0208)
Syntax
public SqlExecutionResult ExecuteSqlString(
	QueryExecutionCancellationToken cancellationToken,
	string sqlToExecute,
	string activeCatalog,
	bool useTransaction,
	bool isBatch
)

Parameters

cancellationToken
Type: SD.LLBLGen.Pro.DBDriverCoreQueryExecutionCancellationToken
The cancellation token which is used to cancel the operation from another thread.
sqlToExecute
Type: SystemString
The sql string to execute. Can contain multiple queries which are then split up as separate queries. If it contains multiple queries, isBatch has to be true
activeCatalog
Type: SystemString
If specified, the active catalog will be set to this value, which will then be embedded into the connection string.
useTransaction
Type: SystemBoolean
If true, it will wrap the queries to execute in a single transaction with isolation level ReadCommitted (the default).
isBatch
Type: SystemBoolean
If true, the sqlToExecute string is considered a string with multiple queries, separated by the default query separator. If false,

Return Value

Type: SqlExecutionResult
A SqlExecutionResult object which can contain one or more queryexecutionresult objects, one for each query executed. If sqltoexecute is empty or null, an empty sqlexecutionresult is returned
See Also