SQL - type is not valid

Question

I have to use...

Code of C#

public double price { get; set; }

Code of SQL

Select id, (0.0) AS price from Product

but during this code I got this error:

"ExceptionMessage":"The specified cast from a materialized 'System.Decimal' type to a nullable 'System.Double' type is not valid."

Also I don't want to change code of c#, For solving I want to change code of Sql (not c#)

cast your sql value to double in C# side price = (double) dbValue — Anonymous Duck
– Anonymous Duck, Commented Jun 9, 2016 at 6:16

Martheen · Accepted Answer · 2016-06-09 06:16:07Z

1

The (0.0) return a numeric type, which is mapped to Decimal. All you need is to cast into float, which is mapped to double, so :

SELECT id, cast(0.0 as float) AS price from Product

should do the trick.

answered Jun 9, 2016 at 6:16

Martheen

5,7874 gold badges37 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1