Dynamic Linq Query

Hi

I'm trying to build a simple dynamic query - so if a user completes cetain fields then these are added to the select -

       var properties = UnitOfWork.ActiveProperty;

       if (!String.IsNullOrEmpty(bedroommin))
       {
           properties = properties.Where(p => p.BedroomCount.CompareTo(bedroommin) > 0);
       }

The code works if I explicitly compare the p.bedroomCount == "1", but I need it to compare a min number of bedrooms.  The database stores bedrooms as varchar ( not sure why, but I cant change it ).

When I run the code above I get an error : The method CompareTo is not supported.

Can anyone please help. - Thanks

We'll look at adding support for String.CompareTo, but in the meantime the only way I can think of doing lexical comparisons on strings is to use the Visual Basic string comparison operator instead (because C# doesn't support the < and > operators on strings):

// need to add reference to Microsoft.VisualBasic.dll
using Microsoft.VisualBasic.CompilerServices;

properties = properties.Where(p => Operators.CompareString(c.Title, "H", true) > 0);