Working with Large Data Types in OLE DB (SQL Server Compact Edition)

The OLE DB Provider for Microsoft SQL Server 2005 Compact Edition supports the ISequentialStream and ILockBytes interfaces for accessing large data values in individual pieces.

ISequentialStream lets clients read parts of a long-value column in a sequential, forward-only manner. ILockBytes can access data in a random manner. By using these structured storage interfaces to access arbitrarily large data values (image and ntext data types), you can avoid potential errors caused by the system trying to read the value into memory in one complete piece.

For more information about using ILockBytes, see ILockBytes (SQL Server Compact Edition).

Community Additions