CSList<T> Range applied before FilteredBy

[guillerot]

"Range" is applied before "FilteredBy" even if "FilteredBy" is called before

CSList<City> cities = City.List ()
  .FilteredBy ( c => (c.Name.IndexOf(Filter) != -1)))
  .Range(1,50);

will behave like

CSList<City> cities = City.List ()
  .Range(1,50);
  .FilteredBy ( c => (c.Name.IndexOf(Filter) != -1)))

[activa]

This is because FilteredBy() with a lambda is executed client-side, while Range() is executed server side. If you use FilteredBy() with a SQL expression it would work as expected.

[guillerot]

That makes sense !
Thanks. ;-)

By the way, does FilteredBy with SQL expression accept "contains" like this :

cities = City.List().FilteredBy("Name=%@Name%", "@Name", Filter);

Like we can with lambda

cities = City.List().FilteredBy ( c => (c.Name.IndexOf(Filter) != -1)));

[guillerot]

any idea ?