This expression works fine for a date range, how would I do the same for a string range:
expression = expression.And(x => x.ProductReceivedDate <= options.ProductReceivedDateEnd)
.And(x => x.ProductReceivedDate >= options.ProductReceivedDateStart);
if (!string.IsNullOrEmpty(options.PlateNumberFrom))
{
expression = expression.And(x => x.InventoryNumber.CompareTo(options.PlateNumberFrom) >= string.Compare(x.InventoryNumber, options.PlateNumberFrom));
}
if (string.IsNullOrEmpty(options.PlateNumberTo))
options.PlateNumberTo = options.PlateNumberFrom;
if (!string.IsNullOrEmpty(options.PlateNumberTo))
{
expression = expression.And(x => x.InventoryNumber.CompareTo(options.PlateNumberTo) <= string.Compare(x.InventoryNumber, options.PlateNumberFrom));
}