Sorting with stored procedures
In the example for sql server they use inline statements and pass in the sortexpression and add it in the statement. If you are using stored procedures how do you use the passed in sortexpression for sorting the grid? the sortexpression being passed in may look like "weight asc" as you may know.
I do see you can add an .Orderby at the end of the return on the Db.Readlist but I'm not sure how that works.
Dennis Tucker, Mar 29, 2012
I'm not totally sure on this one, as I don't have more details about the Db-object, but I assume it's just a DataContext. In that case queries like e.g. ReadList() return an IEnumerable<T>. That means a OrderBy-statement after ReadList(proc, Make, parms) would just adjust your actual query string for a db-query (when it is actually done).
An example for a OrderBy is include in the sample-sourcecode below.
Florian Schaeffler, Apr 03, 2012