SqliteDataReader Class

Definition

Namespace:

Microsoft.Data.Sqlite

Assembly:

Microsoft.Data.Sqlite.dll

Package:

Microsoft.Data.Sqlite.Core v7.0.0

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

DbDataReader

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.