DataProvider Class

Definition

exeposes the results as a tsql as a DataTable or a data reader executes necessary postprocesses and type conversions

public class DataProvider : IDisposable, System.Data.IDataReader
type DataProvider = class
    interface IDataReader
    interface IDataRecord
    interface IDisposable
Public Class DataProvider
Implements IDataReader, IDisposable
Inheritance
DataProvider
Implements

Constructors

DataProvider(StatementBuilder)

initialize with SatatementBuilder, default retrive mode is DataReader

DataProvider(StatementBuilder, DataProvider+RetriveMode)

initialize with SatatementBuilder, and retrive mode

Properties

Depth

always 1

FieldCount

number of columns

IsClosed

is DataReader closed

Item[Int32]

int indexer

Item[String]

string indexer

RecordsAffected

Returns the number of records affected. Will always be -1.

Methods

Close()

clear internal data, cancel any data reader pipe, close reader, disconnect

Dispose()

dispose the object

GetBoolean(Int32)

get data for column i as the given type

GetByte(Int32)

get data for column i as the given type

GetBytes(Int32, Int64, Byte[], Int32, Int32)

get data for column i as the given type

GetChar(Int32)

get data for column i as the given type

GetChars(Int32, Int64, Char[], Int32, Int32)

get data for column i as the given type

GetData(Int32)

not supported, always null

GetDataTypeName(Int32)

get type name for column at ordinal i

GetDateTime(Int32)

get data for column i as the given type

GetDecimal(Int32)

get data for column i as the given type

GetDouble(Int32)

get data for column i as the given type

GetFieldType(Int32)

get type for column at ordinal i

GetFloat(Int32)

get data for column i as the given type

GetGuid(Int32)

get data for column i as the given type

GetInt16(Int32)

get data for column i as the given type

GetInt32(Int32)

get data for column i as the given type

GetInt64(Int32)

get data for column i as the given type

GetName(Int32)

get column name for ordinal i

GetOrdinal(String)

get ordinal for column name

GetSchemaTable()

get empty DataTable describing the schema

GetString(Int32)

get data for column i as the given type

GetValue(Int32)

get data for column i as Object

GetValues(Object[])

get data for the row as an array of Object

InitRowDataManipulation(ArrayList, SortedList)

init data structures so that row manipulation is done eficiently

InitSchemaTable(ArrayList)

Creates a empty DataTable that reflects the schema of the retrieved data.

IsDBNull(Int32)

true if the data for ordinal i is null

NextResult()

nop, always returns false

Read()

advances to next row, closes in case of failure

SetConnectionAndQuery(ExecuteSql, String)

the means to execute the query ( execSql ) and the query ( query ) it executes the query and gets a data reader if retrive mode is DataTable it proceeds to fill it

Applies to