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.10.0.0 (5.10.0)
Syntax public SqlExecutionResult ExecuteSqlString(
QueryExecutionCancellationToken cancellationToken,
string sqlToExecute,
string activeCatalog,
bool useTransaction,
bool isBatch
)
Public Function ExecuteSqlString (
cancellationToken As QueryExecutionCancellationToken,
sqlToExecute As String,
activeCatalog As String,
useTransaction As Boolean,
isBatch As Boolean
) As SqlExecutionResult
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:
SqlExecutionResultA 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