The following statement is in my stored procedure. In the LINQ designer, I am expecting that 'IsON' field to be mapped using datatype bool, but I get the data type as string in LINQ class. I tried 'True' and 1 also in the CASE statement but I am not getting the bool data type.
How can I get the data type in LINQ class as bool? Any other alternative to write the statement?
SELECT
CASE
WHEN DATEDIFF(DAY,GETUTCDATE(),T1.ExpiryDate) > 0 THEN 'true'
ELSE 'false'
END IsON
FROM myTable T1
Thanks in advance
KDV