Using If statement in Linq to SQL
Dim Query = From E In db.Employee Select E

Dim Query = From E In db.Employee Select New With _
{ _
    .Id = E.Id, _
    .Name = E.Name, _
    .IsActive = E.IsActive ? "Active" : "Inactive" _
    ' ... all employee fields except IsActive, '
}

<asp:BoundField DataField="IsActive" HeaderText="IsActive" />

<asp:TemplateField HeaderText="IsActive">
    <ItemTemplate>
        <%# GetIsActiveText((bool)Eval("IsActive")) %>
    </ItemTemplate>
</asp:TemplateField>

ActiveStr = e.IsActive?"Active":"Inactive"

Dim Query = From e In db.Employee
      select
      new
      {
       ID = e.ID,
       ActiveStr = e.IsActive?"Active":"Inactive"
      };

Dim query = From e In db.Employee
            Select e.ID,
                   ActiveStr = If(e.IsActive,"Active","Inactive")