See Also

SQLiteDataReader Class  | Devart.Data.SQLite Namespace  | SQLiteConnection Class  | SQLiteCommand Class

See AlsoDevart.Data.SQLiteSend comments on this topic.

SQLiteDataReader Class Members

Devart.Data.SQLite Namespace : SQLiteDataReader Class

SQLiteDataReader overview

Public Properties

Public Property Depth (Inherited from Devart.Common.DbDataReaderBase)Gets a value indicating the depth of nesting for the current row.
Public Property EndOfDataOverridden. Indicates whether the SQLiteDataReader has been read completely.
Public Property FieldCountOverridden. Gets the number of columns in the current row.
Public Property HasRowsOverridden. Gets a value indicating whether the SQLiteDataReader contains one or more rows.
Public Property IsClosed (Inherited from Devart.Common.DbDataReaderBase)Gets a value indicating whether the data reader is closed.
Public Property Item (Inherited from Devart.Common.DbDataReaderBase)Overloaded. Gets the value of the specified column in its native format given the column name.
Public Property RecordsAffectedOverridden. Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.
Public Property VisibleFieldCount (Inherited from System.Data.Common.DbDataReader)Gets the number of fields in the DbDataReader that are not hidden.

Public Methods

Public Method CloseOverridden. Closes the SQLiteDataReader object.
Public Method CreateObjRef (Inherited from System.MarshalByRefObject)Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Public Method GetBooleanOverloaded. Overridden. Gets the value of the specified column as a Boolean.
Public Method GetByteOverloaded. Overridden. Gets the value of the specified column as a byte.
Public Method GetBytesOverloaded. Overridden. Reads a stream of bytes from the specified column offset into the buffer as an array starting at the given buffer offset.
Public Method GetCharOverloaded. Overridden. Gets the value of the specified column as a single character.
Public Method GetCharsOverloaded. Overridden. Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
Public Method GetDataTypeNameOverloaded. Overridden. Gets the name of the source data type.
Public Method GetDateTimeOverloaded. Overridden. Gets the value of the specified column as a DateTime object.
Public Method GetDateTimeOffsetOverloaded. Overridden. Gets the value of the specified column as an DateTimeOffset object.
Public Method GetDecimalOverloaded. Overridden. Gets the value of the specified column as a Decimal object.
Public Method GetDoubleOverloaded. Overridden. Gets the value of the specified column as a double-precision floating point number.
Public Method GetEnumeratorOverridden. Fills IEnumerator object with data from SQLiteDataReader.
Public Method GetFieldTypeOverloaded. Overridden. Gets the Type that is the data type of the object.
Public Method GetFloatOverloaded. Overridden. Gets the value of the specified column as a single-precision floating point number.
Public Method GetGuidOverloaded. Overridden. Gets the value of the specified column as a globally-unique identifier (GUID).
Public Method GetInt16Overloaded. Overridden. Gets the value of the specified column as a 16-bit signed integer.
Public Method GetInt32Overloaded. Overridden. Gets the value of the specified column as a 32-bit signed integer.
Public Method GetInt64Overloaded. Overridden. Gets the value of the specified column as a 64-bit signed integer.
Public Method GetLifetimeService (Inherited from System.MarshalByRefObject)Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Public Method GetNameOverridden. Gets the name of the specified column.
Public Method GetOrdinalOverridden. Gets the column ordinal, given the name of the column.
Public Method GetProviderSpecificFieldTypeOverloaded. Overridden. Gets the Type that is the provider-specific data type of the object.
Public Method GetProviderSpecificValueOverloaded. Overridden. Gets the value of the specified column. If possible, a provider-specific type is used.
Public Method GetProviderSpecificValuesOverridden. Gets all column values for the current row. If possible, a provider-specific type is used.
Public Method GetSchemaTableOverridden. Returns a SQLiteDataReader that describes the column metadata of the SQLiteDataReader.
Public Method GetSQLiteBlobOverloaded. Gets the value of the specified column as a SQLiteBlob object.
Public Method GetSQLiteDateTimeOverloaded. Gets the value of the specified column as a SQLiteDateTime object.
Public Method GetSQLiteTextOverloaded. Gets the value of the specified column as a SQLiteText object.
Public Method GetSQLiteTypeOverloaded. Gets the value of the specified column as a SQLiteType object.
Public Method GetStringOverloaded. Overridden. Gets the value of the specified column as a string.
Public Method GetTimeSpanOverloaded. Gets the value of the specified column as a TimeSpan object.
Public Method GetValueOverloaded. Overridden. Gets the value of the specified column in its native format.
Public Method GetValuesOverridden. Gets all column values for the current row.
Public Method InitializeLifetimeService (Inherited from System.MarshalByRefObject)Obtains a lifetime service object to control the lifetime policy for this instance.
Public Method IsDBNullOverloaded. Overridden. Gets a value indicating whether the column contains non-existent or missing values.
Public Method NextResultOverridden. Advances the data reader to the next result, when reading the results of batch SQL statements.
Public Method ReadOverridden. Advances the SQLiteDataReader to the next record.

See Also

SQLiteDataReader Class  | Devart.Data.SQLite Namespace  | SQLiteConnection Class  | SQLiteCommand Class

 

 


© 2008 - 2014 Devart. All Rights Reserved.