| SqlExecute Properties | MSBuild Extension Pack Help 4.0.12.0 |
The SqlExecute type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
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
|
|
|
CommandTimeout |
Sets the timeout in seconds. Default is 30
|
|
|
ConnectionString |
Sets the connection string to use for executing the Sql or Files
|
|
|
FailedScripts |
A list of failed scripts. Each will have metadata item ErrorMessage set to the error encountered.
|
|
|
Files |
Sets the files to execute
|
|
|
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.
|
|
|
Parameters |
Sets the parameters to substitute at execution time. These are CASE SENSITIVE.
|
|
|
RawReaderResult |
Gets the raw output from the reader
|
|
|
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.
|
|
|
Retry |
Specifies whether files should be re-executed if they initially fail
|
|
|
ScalarResult |
Gets the scalar result
|
|
|
Sql |
Sets the Sql to execute
|
|
|
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.
|
|
|
UseTransaction |
Set to true to run the sql within a transaction
|
See Also