[xikky]

For a search query by string, I use the following code to search for records, in this case within the Entity Courses.

in the below example, code and title are 2 string variables.

var list = from course in Entity.Courses
where ((code == "" || course.courseCode.Equals(code))
  && (title == "" || course.courseTitle.Equals(title))
select new Course();

But how do I go about to search by an int and a boolean?

If I use the same methods I get this error: DbComparisonExpression requires arguments with comparable types.

I tried .ToString(), .Value.ToString(), but all for nothing.

[Nakor]

Create a string variable using the int or bool and pass that string variable into your query.

var intToString = myInteger.ToString();

var list = from course in Entity.Courses
           where ((code == "" || course.courseCode.Equals(intToString))
                 && (title == "" || course.courseTitle.Equals(title))
           select new Course();