asp.net mvc - Comparing bool and string in c#

Question

I have a search method and I want to search the bool value in the table. IsFallBack is bool and displaying in the table as true or false.

 if (!string.IsNullOrEmpty(searchIsFallBack))
            {
                tableData = (IOrderedQueryable<TableData>)tableData.Where(m => m.IsFallBack.ToString() == searchIsFallBack);
            }

When I try to search program throws an exception: System.InvalidOperationException: 'The LINQ expression could not be translated.

searchValue is the value that the user enters t? the search box How can I compare the bool value and searched value?

question from:https://stackoverflow.com/questions/66062266/comparing-bool-and-string-in-c-sharp

Answer 1

Simple solution:

  if (!string.IsNullOrEmpty(searchIsFallBack))
    {
        if(searchIsFallBack == "true")
        {
            tableData = (IOrderedQueryable<TableData>)tableData.Where(m => m.IsFallBack);
        }
        else
        {
            tableData = (IOrderedQueryable<TableData>)tableData.Where(m => !m.IsFallBack);
        }
    }