DbRangeOptions Enumeration

Visual Studio 2010

Specifies the options used by the SetRange method when specifying the index range over which to seek.

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)

C#
C++
F#
JScript
VB
Copy 
[FlagsAttribute]
public enum class DbRangeOptions

Member nameDescription
InclusiveStartIncludes the startData value in the range.
InclusiveEndIncludes the endData value in the range.
ExclusiveStartExcludes the startData value from the range.
ExclusiveEndExcludes the endData value from the range.
ExcludeNullsExcludes nullptr values from the range.
PrefixSpecifies a range in which index values begin with the value of startData. When using the Prefix option, endData must be set to nullptr.
MatchSpecifies a range in which index values match the value of startData. When using the Match option, endData must be set to nullptr.
DefaultEquivalent to setting both the InclusiveStart and InclusiveEnd flags.

If you specify the Match or Prefix option, the endData value must be nullptr.

You cannot combine the Match and ExcludeNulls options.

In this example, the range options for the Seek operation on the index are specified as InclusiveStart or InclusiveEnd when calling the SetRange method.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Show: