How in Linq to entity replace true or false with On or Off?

Question

I need to bind grid with linq to entity(asp C#), when Im binding I need to replace true or false with On or Off. how I can accomplish it?

ex.

var t = from k in entity.table select k.IsActive;

so in result if

IsActive == true I need to return On
IsActive == false I need to return Off

Answer 1

try this

var t = from k in entity.table select k.IsActive.GetValueOrDefault() ? "On" : "Off";

Answer 2

Have you tried this?

var t = from k in entity.table select (k.IsActive ? On : Off); 

Answer 3

var t = from k in entity.table select k.IsActive ? "On" : "Off";