ADO.NET Client
- Last Updated: May 12, 2026
- 1 minute read
- OpenAccess SDK
- Version 9.0
- Documentation
Note: The ADO and ADO.NET clients are currently available only in OpenAccess SDK 8.1. However, they are compatible with the OpenAccess SDK 9.0 server.
The following table lists the data types that the ADO.NET Client supports for the OpenAccess SDK SQL engine:
Mapping OpenAccess SDK Data Types to .NET Framework Data Types
| OpenAccess Data Type | .NET Framework Type |
| BIGINT | Int64 |
| BINARY | Byte[] |
| BIT | Boolean |
| CHAR | StringChar[] |
| DATE | DateTime |
| DOUBLE | Double |
| FLOAT | Double |
| INTEGER | Int32 |
| LONGVARBINARY | Byte[] |
| LONGVARCHAR | String |
| NUMERIC(p,s) | Decimal |
| REAL | Single |
| SMALLINT | Int16 |
| TINYINT | Byte[] |
| TIME | TimeSpan |
| TIMESTAMP | DateTime |
| VARBINARY | Byte[] |
| VARCHAR | StringChar[] |
| WCHAR | String |
| WLONGVARCHAR | String |
| WVARCHAR | String |