C# Class TSqlFlex.Core.SqlRunParameters

Inheritance: IDisposable
Show file Open project: nycdotnet/TSqlFlex Class Usage Examples

Public Properties

Property Type Description
command System.Data.SqlClient.SqlCommand
completedResultsCount System.UInt32
connStringBuilder System.Data.SqlClient.SqlConnectionStringBuilder
exceptionCount int
exceptionsText StringBuilder
outputFiles List
outputType string
resultsText StringBuilder
sqlToRun string
worksheetIsValid bool

Public Methods

Method Description
CopyStreamToEnd ( Stream source, Stream destination ) : void
Dispose ( ) : void
SqlRunParameters ( System.Data.SqlClient.SqlConnectionStringBuilder csb, string sqlToRun, string outputType, string outputFileName = "" ) : System
WriteToStream ( string dataToWrite ) : void
flushAndCloseOutputStreamIfNeeded ( ) : void
openNewOutputStream ( ) : void
outputFilename ( ) : string
saveOutputStreamTo ( string streamName, string saveAsFileName ) : void
saveOutputStreamsTo ( string saveAsFileNameWithAsteriskForIndex ) : void

Private Methods

Method Description
getNextFileName ( ) : string

Method Details

CopyStreamToEnd() public static method

public static CopyStreamToEnd ( Stream source, Stream destination ) : void
source Stream
destination Stream
return void

Dispose() public method

public Dispose ( ) : void
return void

SqlRunParameters() public method

public SqlRunParameters ( System.Data.SqlClient.SqlConnectionStringBuilder csb, string sqlToRun, string outputType, string outputFileName = "" ) : System
csb System.Data.SqlClient.SqlConnectionStringBuilder
sqlToRun string
outputType string
outputFileName string
return System

WriteToStream() public method

public WriteToStream ( string dataToWrite ) : void
dataToWrite string
return void

flushAndCloseOutputStreamIfNeeded() public method

public flushAndCloseOutputStreamIfNeeded ( ) : void
return void

openNewOutputStream() public method

public openNewOutputStream ( ) : void
return void

outputFilename() public method

public outputFilename ( ) : string
return string

saveOutputStreamTo() public method

public saveOutputStreamTo ( string streamName, string saveAsFileName ) : void
streamName string
saveAsFileName string
return void

saveOutputStreamsTo() public method

public saveOutputStreamsTo ( string saveAsFileNameWithAsteriskForIndex ) : void
saveAsFileNameWithAsteriskForIndex string
return void

Property Details

command public property

public SqlCommand,System.Data.SqlClient command
return System.Data.SqlClient.SqlCommand

completedResultsCount public property

public UInt32,System completedResultsCount
return System.UInt32

connStringBuilder public property

public SqlConnectionStringBuilder,System.Data.SqlClient connStringBuilder
return System.Data.SqlClient.SqlConnectionStringBuilder

exceptionCount public property

public int exceptionCount
return int

exceptionsText public property

public StringBuilder exceptionsText
return StringBuilder

outputFiles public property

public List outputFiles
return List

outputType public property

public string outputType
return string

resultsText public property

public StringBuilder resultsText
return StringBuilder

sqlToRun public property

public string sqlToRun
return string

worksheetIsValid public property

public bool worksheetIsValid
return bool