Previous Page Next Page

SqlHelper.ExecuteReader method (1 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the statement returning a data reader.

public static IDataReader ExecuteReader(IDbConnection connection, SqlQuery query, 
    ILogger logger = null)
parameter description
connection The connection.
query The query.
logger Logger

Return Value

Data reader with results

See Also

SqlHelper.ExecuteReader method (2 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the statement returning a data reader.

public static IDataReader ExecuteReader(IDbConnection connection, string commandText, 
    ILogger logger = null)
parameter description
connection The connection.
commandText The command text.
logger Logger

Return Value

Data reader with results

See Also

SqlHelper.ExecuteReader method (3 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the query.

public static IDataReader ExecuteReader(this SqlQuery query, IDbConnection connection, 
    ILogger logger = null)
parameter description
query The query.
connection The connection.
logger Logger

Return Value

A data reader with results.

See Also

SqlHelper.ExecuteReader method (4 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the statement returning a data reader.

public static IDataReader ExecuteReader(IDbConnection connection, SqlQuery query, 
    Dictionary<string, object> param, ILogger logger = null)
parameter description
connection The connection.
query The query.
param The parameters.
logger Logger

Return Value

Data reader with results

See Also

SqlHelper.ExecuteReader method (5 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the command returning a data reader.

public static IDataReader ExecuteReader(IDbConnection connection, string commandText, 
    IDictionary<string, object> param, ILogger logger = null)
parameter description
connection The connection.
commandText The command text.
param The parameters.
logger Logger

Exceptions

exception condition
ArgumentNullException connection is null

See Also

SqlHelper.ExecuteReader method (6 of 6)

namespace: Serenity.Data   assembly: Serenity.Net.Data

Executes the query.

public static IDataReader ExecuteReader(this SqlQuery query, IDbConnection connection, 
    Dictionary<string, object> param, ILogger logger = null)
parameter description
query The query.
connection The connection.
param The parameters.
logger Logger

Return Value

A data reader with results

See Also