LINQ to SQL Invalid Cast Issue
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
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.
smallmoney
maps to Decimal
, see msdn (numeric mapping)
精彩评论