ADOMD.NET - Microsoft SQL Server 2008 Analysis Services - page 595

CHAPTER 33

IN THIS CHAPTER

. Creating an ADOMD.NET Project

ADOMD.NET

. Writing Analytical Applications

. ADOMD.NET Connections

. Working with Metadata Objects

. AdomdCommand

. Using the CellSet Object to

Work with Multidimensional
Data

A DOMD.NET is both an ADO.NET provider for Analysis
Services and an object model designed to simplify access to
multidimensional data stored in Microsoft SQL Server
Analysis Services. You use this object model to develop
analytical applications, and not for administering Analysis
Services. ADOMD.NET provides users a view of the data in
the data source. Only the data that the security restrictions
allow this user to see is available to him.

. Working with Data in Tabular

Format

. Which Should You Use:

AdomdDataReader or CellSet ?

. Using Parameters in MDX

Requests

In this chapter, we provide an overview of the classes in the
object model and various examples of their use. We not
only show you what the code looks like, we also explain
what is happening under the covers of the function calls.
We also give you advice about which objects to use for
different scenarios.

. Asynchronous Execution and

Cancellation of Commands

. Error Handling

Creating an ADOMD.NET Project

First, we're going to create a project in Microsoft Visual
Studio. You don't have to use Visual Studio to use
ADOMD.NET, but your life as a developer will be easier if
you do. We explain how to use ADOMD.NET with Visual
Studio in great detail for any reader who is not familiar
with Visual Studio.

Open Visual Studio and create a new project in the New
Project dialog box, shown in Figure 33.1.