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 |