10.5. ADO.NET and Structured Files, Multidimensional Data, and ORDBMS

The .NET APIs do not directly provide anything for retrieval and query of multimedia data types, time series, or multidimensional data. Microsoft made a rather successful attempt to standardize multidimensional data access using a two-pronged standard: OLE DB for OLAP as an API, and the MDX (Multidimensional Extensions to SQL) query language. In addition, a simplified API that was compatible with the type library—that is, usable by Visual Basic 6 and ADO.NET—was modeled on classic ADO. This API, called ADOMD (ADO for Multidimensional), was not ported to interoperate with ADO.NET. This means that it must be used through interoperability between .NET and COM, using TLBIMP to ...

Get Essential ADO.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.