Stop Implicit Typecast

Question

My issue is within AMO in a C# console application. I have a DataSourceView that has a table which has a column of type Decimal.

When I try to create a measure out of it, AMO says that it cannot create a measure because the data type is string.

I believe there may be some implicit typecasting going on in the background that is causing this.

Is there an application wide setting to stop implict typecasting?

Answer 1

It sounds like you need to parse the string for the decimal -- decimal.Parse(s);

Of course you would want to make sure you handle the case where the string is not a decimal number.

Alternatively, you could use System.Convert

Answer 2

I think it depends on the implementation of DataSourceView being used.

DataSourceView takes a data source, but can do any sort of transformation on that data. The result of an ExecuteSelect() call is just an Enumerable -- there is no guarantee of what you get out in terms of type fidelity; it is entirely contingent upon the implementation.