Share via


SqliteDataReader Class

Definition

Provides methods for reading the result of a command executed against a SQLite database.

public class SqliteDataReader : System.Data.Common.DbDataReader
type SqliteDataReader = class
    inherit DbDataReader
Public 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.

Applies to