CompareTo() throws exception

Jul 18, 2014 at 3:13 PM
I'm trying a simple GreaterThan on a string field. Of course, the string class doesn't define a GreaterThan operator, so I'm using String.CompareTo():
var foo = myDbContext.Foos.Where(f => f.fooId.CompareTo("Z") > 0).ToList();
This works fine, when myDbContext is connected to a SqlServer database. But when it's connected to an Effort database, I get an exception:
The binary operator GreaterThan is not defined for the types 'System.String' and 'System.String'.
Aug 21, 2014 at 2:17 PM
I posted this some weeks ago, and I've seen no response.

Any ideas?
Sep 8, 2014 at 6:44 PM

Sorry I was not able spare time for Effort during summer. This feature seem to be easily implemented, so I will do it in the near future.
Sep 8, 2014 at 6:44 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.