ADOMD.NET was originally released as the ADOMD.NET 8.0 SDK. This SDK provided communication with Microsoft SQL Server 2000 Analysis Services.
Included with this release of Microsoft SQL Server Analysis Services is a new version of ADOMD.NET—ADOMD.NET 9.0. This new version of ADOMD.NET provides communication with both SQL Server 2000 Analysis Services and SQL Server Analysis Services.
It is the ability of ADOMD.NET 9.0 to communicate with SQL Server Analysis Services that is the most important difference between ADOMD.NET 9.0 and ADOMD.NET 8.0. ADOMD.NET 9.0 is able to support all of the capabilities found in SQL Server Analysis Services, while ADOMD.NET 8.0 is not able to support any of these new features.
Another important difference between the two versions is in the Microsoft .NET Framework Class Library used by each version. ADOMD.NET 9.0 requires that the .NET Framework Class Library version 2.0 be installed on the client. However, ADOMD.NET 8.0 requires that the .NET Framework Class Library version 1.0 Service Pack 2 (SP2) or later be installed.
The following table summarizes the differences between ADOMD.NET 9.0 and ADOMD.NET 8.0.
|
Feature
|
ADOMD.NET 8.0
|
ADOMD.NET 9.0
|
|---|
|
.NET Framework Runtime Requirements
|
Requires installation of the .NET Framework Class Library 1.0 SP2 (or later) on the client.
|
Requires installation of the .NET Framework Class Library 2.0 (or later) on the client.
|
|
Metadata Objects
|
CubeDef, OlapInfo
|
CubeDef, OlapInfo, Kpi, MiningModels, MiningServices, MiningStructures
|
|
Server Connectivity
|
-
Can connect to SQL Server 2000 Analysis Services.
-
Can connect to SQL Server Analysis Services, but the object model used by ADOMD.NET 8.0 cannot use any of the new Analysis Services features.
|
-
Can connect to SQL Server 2000 Analysis Services.
-
Can connect to SQL Server Analysis Services, and the object model used by ADOMD.NET 9.0 can use all new Analysis Services features.
-
Can have the following, additional connection string properties set: LocaleIdentifier, Location, Restricted Client, Persist Security Info, SessionID, Transport Compression, Compression Level, SspropInitAppName, and ClientProcessID. For more information, see ConnectionString.
|
|
Performance
|
|
Optimized to perform faster than ADOMD.NET 8.0 in many scenarios.
|
See Also