C# Class ALE.Sql.Sql

Inheritance: IDisposable
Show file Open project: blesh/ALE

Protected Properties

Property Type Description
Connection System.Data.SqlClient.SqlConnection
ConnectionString string

Public Methods

Method Description
Create ( string connectionString ) : Sql
CreateCommand ( string commandText, object args = null, CommandType commandType = CommandType.Text ) : SqlCommand
Dispose ( ) : void
ExecuteNonQuery ( SqlCommand cmd, int>.Action callback = null ) : Sql
ExecuteNonQuery ( string commandText, int>.Action callback = null ) : Sql
ExecuteNonQuery ( string commandText, object args, int>.Action callback = null ) : Sql
ExecuteNonQuery ( string commandText, object args, CommandType commandType, int>.Action callback = null ) : Sql
ExecuteNonQueryCallback ( IAsyncResult result ) : void
ExecuteReader ( SqlCommand cmd, SqlDataReader>.Action callback ) : Sql
ExecuteReader ( string commandText, SqlDataReader>.Action callback ) : Sql
ExecuteReader ( string commandText, object args, SqlDataReader>.Action callback ) : Sql
ExecuteReader ( string commandText, object args, CommandType cmdType, SqlDataReader>.Action callback ) : Sql

Private Methods

Method Description
ConvertObjectToSqlParams ( object args ) : System.Data.SqlClient.SqlParameter[]
EndExecuteReader ( IAsyncResult result ) : void
Sql ( string connectionString ) : System

Method Details

Create() public static method

public static Create ( string connectionString ) : Sql
connectionString string
return Sql

CreateCommand() public method

public CreateCommand ( string commandText, object args = null, CommandType commandType = CommandType.Text ) : SqlCommand
commandText string
args object
commandType CommandType
return System.Data.SqlClient.SqlCommand

Dispose() public method

public Dispose ( ) : void
return void

ExecuteNonQuery() public method

public ExecuteNonQuery ( SqlCommand cmd, int>.Action callback = null ) : Sql
cmd System.Data.SqlClient.SqlCommand
callback int>.Action
return Sql

ExecuteNonQuery() public method

public ExecuteNonQuery ( string commandText, int>.Action callback = null ) : Sql
commandText string
callback int>.Action
return Sql

ExecuteNonQuery() public method

public ExecuteNonQuery ( string commandText, object args, int>.Action callback = null ) : Sql
commandText string
args object
callback int>.Action
return Sql

ExecuteNonQuery() public method

public ExecuteNonQuery ( string commandText, object args, CommandType commandType, int>.Action callback = null ) : Sql
commandText string
args object
commandType CommandType
callback int>.Action
return Sql

ExecuteNonQueryCallback() public method

public ExecuteNonQueryCallback ( IAsyncResult result ) : void
result IAsyncResult
return void

ExecuteReader() public method

public ExecuteReader ( SqlCommand cmd, SqlDataReader>.Action callback ) : Sql
cmd System.Data.SqlClient.SqlCommand
callback SqlDataReader>.Action
return Sql

ExecuteReader() public method

public ExecuteReader ( string commandText, SqlDataReader>.Action callback ) : Sql
commandText string
callback SqlDataReader>.Action
return Sql

ExecuteReader() public method

public ExecuteReader ( string commandText, object args, SqlDataReader>.Action callback ) : Sql
commandText string
args object
callback SqlDataReader>.Action
return Sql

ExecuteReader() public method

public ExecuteReader ( string commandText, object args, CommandType cmdType, SqlDataReader>.Action callback ) : Sql
commandText string
args object
cmdType CommandType
callback SqlDataReader>.Action
return Sql

Property Details

Connection protected property

protected SqlConnection,System.Data.SqlClient Connection
return System.Data.SqlClient.SqlConnection

ConnectionString protected property

protected string ConnectionString
return string