topic Re: Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient in Developer

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

mihies — Tue, 16 Jan 2024 15:40:18 GMT

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?

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

Anonymous — Wed, 17 Jan 2024 02:18:44 GMT

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

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

mihies — Wed, 17 Jan 2024 07:06:19 GMT

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.