DataProvider Class
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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, DataProvider+RetriveMode) |
initialize with SatatementBuilder, and retrive mode |
| DataProvider(StatementBuilder) |
initialize with SatatementBuilder, default retrive mode is DataReader |
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 |