Export (0) Print
Expand All

Large Data Types in OLE DB (SQL Server Compact)

The OLE DB Provider for Microsoft SQL Server Compact 3.5 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).

© 2015 Microsoft