yes, this seems to be a glitch. With MSSQL 2000, varchar(max) columns could not be sorted or compared except for LIKE and IS NULL. Later versions seem to have lifted this restriction, but our default converter initialization was not changed accordingly. I will mark this as a bug.
Workaround: Please specify the converter to be used for varchar(max) columns as VariableLengthAnsiStringConverter; and for nvarchar(max) use VariableLengthStringConverter. You can do that most efficiently either in the fluent mapping code by specifying
or by using the .rlinq editor (Model Operations-> Select Members, Column, SqlType varchar(max) -> Operations : Change Converter).
Please excuse the inconvenience caused by this.
OpenAccess ORM is now Telerik Data Access
. For more information on the new names, please, check out the Telerik Product Map