SqliteDataReader 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.
Provides methods for reading the result of a command executed against a SQLite database.
public class SqliteDataReader : System.Data.Common.DbDataReadertype SqliteDataReader = class
inherit DbDataReaderPublic Class SqliteDataReader
Inherits DbDataReader- Inheritance
-
SqliteDataReader
Properties
| Depth |
Gets the depth of nesting for the current row. Always zero. |
| FieldCount |
Gets the number of columns in the current row. |
| Handle |
Gets a handle to underlying prepared statement. |
| HasRows |
Gets a value indicating whether the data reader contains any rows. |
| IsClosed |
Gets a value indicating whether the data reader is closed. |
| Item[Int32] |
Gets the value of the specified column. |
| Item[String] |
Gets the value of the specified column. |
| RecordsAffected |
Gets the number of rows inserted, updated, or deleted. -1 for SELECT statements. |
Methods
| Close() |
Closes the data reader. |
| Dispose(Boolean) |
Releases any resources used by the data reader and closes it. |
| GetBoolean(Int32) |
Gets the value of the specified column as a Boolean. |
| GetByte(Int32) |
Gets the value of the specified column as a Byte. |
| GetBytes(Int32, Int64, Byte[], Int32, Int32) |
Reads a stream of bytes from the specified column. Not supported. |
| GetChar(Int32) |
Gets the value of the specified column as a Char. |
| GetChars(Int32, Int64, Char[], Int32, Int32) |
Reads a stream of characters from the specified column. Not supported. |
| GetDataTypeName(Int32) |
Gets the declared data type name of the specified column. The storage class is returned for computed columns. |
| GetDateTime(Int32) |
Gets the value of the specified column as a DateTime. |
| GetDateTimeOffset(Int32) |
Gets the value of the specified column as a DateTimeOffset. |
| GetDecimal(Int32) |
Gets the value of the specified column as a Decimal. |
| GetDouble(Int32) |
Gets the value of the specified column as a Double. |
| GetEnumerator() |
Gets an enumerator that can be used to iterate through the rows in the data reader. |
| GetFieldType(Int32) |
Gets the data type of the specified column. |
| GetFieldValue<T>(Int32) |
Gets the value of the specified column. |
| GetFloat(Int32) |
Gets the value of the specified column as a Single. |
| GetGuid(Int32) |
Gets the value of the specified column as a Guid. |
| GetInt16(Int32) |
Gets the value of the specified column as a Int16. |
| GetInt32(Int32) |
Gets the value of the specified column as a Int32. |
| GetInt64(Int32) |
Gets the value of the specified column as a Int64. |
| GetName(Int32) |
Gets the name of the specified column. |
| GetOrdinal(String) |
Gets the ordinal of the specified column. |
| GetSchemaTable() |
Returns a System.Data.DataTable that describes the column metadata of the System.Data.Common.DbDataReader. |
| GetStream(Int32) |
Retrieves data as a Stream. If the reader includes rowid (or any of its aliases), a SqliteBlob is returned. Otherwise, the all of the data is read into memory and a MemoryStream is returned. |
| GetString(Int32) |
Gets the value of the specified column as a String. |
| GetTextReader(Int32) |
Retrieves data as a TextReader. |
| GetTimeSpan(Int32) |
Gets the value of the specified column as a TimeSpan. |
| GetValue(Int32) |
Gets the value of the specified column. |
| GetValues(Object[]) |
Gets the column values of the current row. |
| IsDBNull(Int32) |
Gets a value indicating whether the specified column is DBNull. |
| NextResult() |
Advances to the next result set for batched statements. |
| Read() |
Advances to the next row in the result set. |