This documentation is archived and is not being maintained.

SqlCeDataReader Class

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

For a list of all members of this type, see SqlCeDataReader Members.


[Visual Basic]
NotInheritable Public Class SqlCeDataReader
   Inherits MarshalByRefObject
   Implements IDataReader, IDisposable, IDataRecord
public sealed class SqlCeDataReader : MarshalByRefObject,
   IDataReader, IDisposable, IDataRecord
public __gc __sealed class SqlCeDataReader : public
   MarshalByRefObject, IDataReader, IDisposable, IDataRecord
public class SqlCeDataReader extends MarshalByRefObject implements
   IDataReader, IDisposable, IDataRecord

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.


To create a SqlCeDataReader, you must call the ExecuteReader method of the SqlCeCommand object, rather than directly using a constructor.

While the SqlCeDataReader is in use, the associated SqlCeConnection is busy serving the SqlCeDataReader. In this state, you can create multiple readers in the same connection.

Changes made to a result set by another process or thread while the data is being read may be visible to the user of the SqlCeDataReader; however, the precise behavior is dependent on when these occur.

IsClosed and RecordsAffected are the only properties that you can call after the SqlCeDataReader is closed. Although the RecordsAffected property can be accessed at any time while the SqlCeDataReader exists, always call Close before returning the value of RecordsAffected to ensure an accurate return value.


Namespace: System.Data.SqlServerCe

Platforms: .NET Compact Framework

Assembly: System.Data.Sqlserverce (in System.Data.Sqlserverce.dll)

See Also

SqlCeDataReader Members | System.Data.SqlServerCe Namespace