C# Class com.rusanu.DBUtil.SqlCmd

Class for sqlcmd functionality

Inheritance: IDisposable

Datei anzeigen Open project: rusanu/com.rusanu.dbutil Class Usage Examples

Public Methods

Method	Description
Dispose ( ) : void
ExecuteFile ( string filePath, string basePath = null ) : bool	Executes a SQL file, from the file path
ExecuteFile ( SqlConnection conn, string filePath ) : void	Executes a SQL file on the given connection
ExecuteReader ( TextReader file, string basePath = null ) : bool	Executes a SQL file, from a TextReader
ExecuteStream ( Stream stream, string basePath = null ) : bool	Executes a SQL file from a stream
ExecuteStream ( SqlConnection conn, Stream stream ) : void
SqlCmd ( SqlConnection conn ) : System	Constructor

Private Methods

Method	Description
ConnectCommand ( string line ) : void
ExecuteBatch ( string batch, uint count ) : bool
GetFullFilePath ( string filePath, string basePath ) : string
OnErrorCommand ( string line ) : void
RunCommand ( string line, string basePath ) : void
SetVarCommand ( string line ) : void
ShellCommand ( string line ) : void

Method Details

Dispose() public method

public Dispose ( ) : void
return	void

ExecuteFile() public method

Executes a SQL file, from the file path

public ExecuteFile ( string filePath, string basePath = null ) : bool
filePath	string	The SQL file to execute
basePath	string	/// The base path to use to qualify relative path of any included files that are to be executed. /// If not supplied this will default to the directory path containing ///
return	bool

ExecuteFile() public static method

Executes a SQL file on the given connection

public static ExecuteFile ( SqlConnection conn, string filePath ) : void
conn	System.Data.SqlClient.SqlConnection	Connection to execute the file on
filePath	string
return	void

ExecuteReader() public method

Executes a SQL file, from a TextReader

public ExecuteReader ( TextReader file, string basePath = null ) : bool
file	TextReader	The SQL file to execute, as a TextReader
basePath	string	The base path to use to qualify relative path of any included files that are to be executed
return	bool

ExecuteStream() public method

Executes a SQL file from a stream

public ExecuteStream ( Stream stream, string basePath = null ) : bool
stream	Stream	The SQL file to execute, as a Stream
basePath	string	The base path to use to qualify relative path of any included files that are to be executed
return	bool

ExecuteStream() public static method

public static ExecuteStream ( SqlConnection conn, Stream stream ) : void
conn	System.Data.SqlClient.SqlConnection
stream	Stream
return	void

SqlCmd() public method

Constructor

public SqlCmd ( SqlConnection conn ) : System
conn	System.Data.SqlClient.SqlConnection	The SQL Connection used to execute the SQL batches
return	System