SqlExecute Properties

MSBuild Extension Pack

SqlExecute Properties MSBuild Extension Pack Help 4.0.12.0

The SqlExecute type exposes the following members.

Properties

  Name Description
Public property CodePage
Allows setting encoding code page to be used. Default is System.Text.Encoding.Default All code pages are listed here: http://msdn.microsoft.com/en-us/library/system.text.encoding
Public property CommandTimeout
Sets the timeout in seconds. Default is 30
Public property ConnectionString
Sets the connection string to use for executing the Sql or Files
Public property FailedScripts
A list of failed scripts. Each will have metadata item ErrorMessage set to the error encountered.
Public property Files
Sets the files to execute
Public property IgnoreScriptErrors
Ignore any script errors, i.e. continue executing any remaining scripts when an error is encountered. Failed scripts will be returned in the FailedScripts output item.
Public property Parameters
Sets the parameters to substitute at execution time. These are CASE SENSITIVE.
Public property RawReaderResult
Gets the raw output from the reader
Public property ReaderResult
Gets the output from a reader in an Item with metadata matching the names of columns. The first column returned will be used as the identity.
Public property Retry
Specifies whether files should be re-executed if they initially fail
Public property ScalarResult
Gets the scalar result
Public property Sql
Sets the Sql to execute
Public property StripMultiLineComments
Specifies whether to parse out multi-line comments before executing. This can be handy if your comments contain GO statements. Please note that if your sql contains code with /* in it, then you should set this to false. Default is true.
Public property UseTransaction
Set to true to run the sql within a transaction
Top
See Also

Reference