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.IDataReadertype DataProvider = class
interface IDataReader
interface IDataRecord
interface IDisposablePublic 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 |