Class SQLExecuterReader

Inheritance
object
SQLExecuterReader
Implements
Inherited Members
Namespace: LemonEdge.API.Core.Reporting
Assembly: LemonEdge.API.dll
Syntax
public class SQLExecuterReader : ISimpleReader, IDisposable

Constructors

SQLExecuterReader(SQLWrapperExecuter, IEntityRetriever)

Declaration
public SQLExecuterReader(SQLWrapperExecuter executer, IEntityRetriever context)
Parameters
Type Name Description
SQLWrapperExecuter executer
IEntityRetriever context

Properties

Columns

The column list.

Declaration
public string[] Columns { get; }
Property Value
Type Description
string[]

Methods

Dispose()

Declaration
public void Dispose()

Dispose(bool)

Declaration
protected virtual void Dispose(bool disposing)
Parameters
Type Name Description
bool disposing

ExecuteQuery()

Executes a query.

Declaration
public Task ExecuteQuery()
Returns
Type Description
Task

GetColumnType(string)

Gets the type of a column, by name.

Declaration
public Type GetColumnType(string colName)
Parameters
Type Name Description
string colName

The name of the column.
Returns
Type Description
Type

GetResultValue(string)

Gets the value for a column.

Declaration
public (object Result, bool IsNull) GetResultValue(string column)
Parameters
Type Name Description
string column

The column.
Returns
Type Description
(object Result, bool IsNull)

GetTotalCount()

Gets the total count of rows.

Declaration
public Task<int> GetTotalCount()
Returns
Type Description
Task<int>

ReadNextResult()

Reads the next result.

Declaration
public Task<bool> ReadNextResult()
Returns
Type Description
Task<bool>

Implements

Extension Methods