Skip to content

accessors-and-rowsets.md

Latest commit

 

History

History
90 lines (75 loc) · 4.6 KB

accessors-and-rowsets.md

File metadata and controls

90 lines (75 loc) · 4.6 KB
title Accessors and Rowsets | Microsoft Docs
ms.custom
ms.date 11/04/2016
ms.reviewer
ms.suite
ms.technology
cpp-windows
ms.tgt_pltfrm
ms.topic article
dev_langs
C++
helpviewer_keywords
accessors [C++]
OLE DB consumer templates, rowset support
OLE DB consumer templates, accessors
rowsets [C++], accessing
bulk rowsets
CAccessorRowset class, accessor types
single rowsets
CArrayRowset class, accessors
CBulkRowset class, accessors
array rowsets
CAccessorBase class
CRowset class, accessors and rowsets
accessors [C++], rowsets
rowsets [C++], supported types
ms.assetid edc9c8b3-1a2d-4c2d-869f-7e058c631042
caps.latest.revision 11
author mikeblome
ms.author mblome
manager ghogen
translation.priority.ht
cs-cz
de-de
es-es
fr-fr
it-it
ja-jp
ko-kr
pl-pl
pt-br
ru-ru
tr-tr
zh-cn
zh-tw

Accessors and Rowsets

To set and retrieve data, OLE DB Templates use an accessor and a rowset through the CAccessorRowset class. This class can handle multiple accessors of different types.

Accessor Types

All accessors derive from CAccessorBase. CAccessorBase provides both parameter and column binding.

The following figure shows the accessor types.

Accessor types
Accessor Classes

  • CAccessor Use this accessor when you know the structure of the database source at design time. CAccessor statically binds a database record, which contains the buffer, to the data source.

  • CDynamicAccessor Use this accessor when you do not know the structure of the database at design time. CDynamicAccessor calls IColumnsInfo::GetColumnInfo to get the database column information. It creates and manages an accessor and the buffer.

  • CDynamicParameterAccessor Use this accessor to handle unknown command types. When you prepare the commands, CDynamicParameterAccessor can get parameter information from the ICommandWithParameters interface, if the provider supports ICommandWithParameters.

  • CDynamicStringAccessor, CDynamicStringAccessorA, and CDynamicStringAccessorW Use these classes when you have no knowledge of the database schema. CDynamicStringAccessorA retrieves data as ANSI strings; CDynamicStringAccessorW retrieves data as Unicode strings.

  • CManualAccessor With this class, you can use whatever data types you want if the provider can convert the type. It handles both result columns and command parameters.

The following table summarizes the support in the OLE DB Template accessor types.

Accessor type Dynamic Handles params Buffer Multiple accessors
CAccessor No Yes User Yes
CDynamicAccessor Yes No OLE DB Templates No
CDynamicParameterAccessor Yes Yes OLE DB Templates No
CDynamicStringAccessor[A,W] Yes No OLE DB Templates No
CManualAccessor Yes Yes User Yes

Rowset Types

The OLE DB Templates support three kinds of rowsets (see the preceding figure): single rowsets (implemented by CRowset), bulk rowsets (implemented by CBulkRowset), and array rowsets (implemented by CArrayRowset). Single rowsets fetch a single row handle when MoveNext is called. Bulk rowsets can fetch multiple row handles. Array rowsets are rowsets that can be accessed using array syntax.

The following figure shows the rowset types.

RowsetType graphic
Rowset Classes

Schema rowsets do not access data in the data store but instead access information about the data store, called metadata. Schema rowsets are typically used in situations in which the database structure is not known at compile time and must be obtained at run time.

See Also

OLE DB Consumer Templates