Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SqlCeCommand::SetRange Method

Restricts the set of rows that will be read by the SqlCeDataReader.

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
public:
void SetRange(
	DbRangeOptions dbRangeOptions, 
	array<Object^>^ startData, 
	array<Object^>^ endData
)

Parameters

dbRangeOptions
Type: System.Data.SqlServerCe::DbRangeOptions
The options used when specifying the range.
startData
Type: array<System::Object>
The starting key values for the range.
endData
Type: array<System::Object>
The ending key values for the range.
ExceptionCondition
InvalidOperationException

IndexName property has not been set.

This method is intended to be a faster alternative to a SELECT statement for retrieving a set of rows from a base table. Instead of a WHERE clause in a SELECT statement, SetRange can be used to quickly retrieve a set of rows based on their index values. For example, to retrieve a set of employees with an employee ID between 1 and 5, you could execute a SELECT statement, but setting a range of 1 to 5 on the employee ID index will greatly improve performance.

This method can only be used when CommandType is set to TableDirect, CommandText is set to a valid base table name, and IndexName is set to a valid index name on the specified base table. When SetRange is used, the SqlCeDataReader returned from ExecuteReader will only return rows whose key values in the specified index match the range.

When Seek is used on a SqlCeDataReader that has a range, Seek will only position on rows in the specified range. For detailed information about SetRange, see the "IRowsetIndex::SetRange" topic in the OLE DB documentation.

This example retrieves data from the Orders table using an index into a SqlCeDataReader. The range on the index on which to Seek is specified by the SetRange method.

No code example is currently available or this language may not be supported.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.