Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient

[mihies]

Let's say I have this MDX query against SQL Server's Analysis Service Adventure Works sample:

select [Measures].[Customer Count] on columns, 
[Date].[Calendar Quarter of Year] on rows
from [Adventure Works]

And I execute it as:

var reader = new AdomdCommand("...").ExecuteReader();

I would expect that

reader.GetFieldType(0);

would return System.Int32, but it returns System.Object. The same is true if I query schema with reader.GetSchemaTable() which is no surprise as I assume the former gets data from later. I also assume this is probably not an exclusive .NET issue. The same is at least true for .NET Framework.

So, is there a way I can get those types when I do a query?

[mihies]

I guess it's related to both and I don't think Adomd client is doing anything significant except for retrieving schema from SQL server. But anyway, I will post there as well.

[v-shex-msft]

Hi @mihies,

According to your description, I think this requirement is more related to use ADO.NET to getting data from SQL server.

For this scenario, I'd like to suggest you post those at the forum to get further support.

.NET - Microsoft Q&A

Regards,

Xiaoxin Sheng