Siphon Interface

Abstraction of the database connection.

C#
public interface Siphon
Derived

Methods

ExecuteNonQuery(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement without the results.

ExecuteReader(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement and returns the reader of the results.

ExecuteLong(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement and returns the scalar result.

Methods Detail

ExecuteNonQuery(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement without the results.

C#
void ExecuteNonQuery(string text, [IReadOnlyDictionary<string, object> parameters = null])

Parameters

text
string

The SQL statement.

parameters
IReadOnlyDictionary<string, object>

The parameters of the statement. This can be null if the statement contains no parameters.

ExecuteReader(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement and returns the reader of the results.

C#
Reservoir ExecuteReader(string text, [IReadOnlyDictionary<string, object> parameters = null])

Parameters

text
string

The SQL statement.

parameters
IReadOnlyDictionary<string, object>

The parameters of the statement. This can be null if the statement contains no parameters.

Returns

The reader of the results.

ExecuteLong(string, IReadOnlyDictionary<string, object>)

Executes the SQL statement and returns the scalar result.

C#
long ExecuteLong(string text, [IReadOnlyDictionary<string, object> parameters = null])

Parameters

text
string

The SQL statement.

parameters
IReadOnlyDictionary<string, object>

The parameters of the statement. This can be null if the statement contains no parameters.

Returns

The scalar result.