ResultSetOptions Enumeration

Sets options for the ResultSetEnumerator.

This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

public enum ResultSetOptions

Member nameDescription
NoneNo ResultSet options are specified.
UpdatableThe ResultSet allows updates.
ScrollableThe ResultSet can be scrolled both forward and backward.
SensitiveThe ResultSet detects changes made to the data source.
InsensitiveThe ResultSet does not detect changes made to the data source.

If you do not set both the Insensitive and Sensitive settings, the ResultSet is Asensitive and will use the fastest cursor based on the other options specified.