LINQ to SQL Invalid Cast Issue

Question

Hello All,

I'm getting an invalid cast exception but I'm not sure why, here is the list of my conversions.

SQL -> VB.NET

char(4) -> String

varchar(50) -> String

tinyint -> Integer

char(1) -> Char

bit -> boolean

smallint -> Integer

smallmoney -> Double

int -> Integer

datetime -> datetime

Thanks in advance for your help

Answer 1

It's possible that smallmoney should go to Decimal instead... but why not just use a binary chop to try the first half, then the second etc to narrow down what's causing the problem?

If you could post the query involved, that would help too.

Answer 2

smallmoney maps to Decimal, see msdn (numeric mapping)