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.

System.Object
   System.MarshalByRefObject
      System.Data.SqlServerCe.SqlCeDataReader

NotInheritable Public Class SqlCeDataReader
   Inherits MarshalByRefObject
   Implements IDataReader, IDisposable, IDataRecord
[C#]
public sealed class SqlCeDataReader : MarshalByRefObject,
   IDataReader, IDisposable, IDataRecord
[C++]
public __gc __sealed class SqlCeDataReader : public
   MarshalByRefObject, IDataReader, IDisposable, IDataRecord
[JScript]
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.

Remarks

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.

Requirements

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