TryExecuteStatements Method

Tries to execute a set of statements provides a detailed result on the individual statements

Syntax

bool TryExecuteStatements( 
   IEnumerable<string> statements,
   bool inTransaction,
   out IReadOnlyList<TSqlResult> result
)

Parameters

statements: the statements to execute
inTransaction: ensure all statements pass with no error or none passes
result: the statements and the individual

Return Value

true if no exception

Remarks

If not executed in a transaction the method may return true with errors included in the result data set. To test if no errors test the result for rows with failed statements

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

IDatabaseTools Interface
IDatabaseTools Members