SqlBind.CSharp

Release Notes

2.0.0 (2024-04-16)

Add LIMIT and OFFSET clauses (after SELECT … ORDER BY …)

Add the SelectTerminator interface, which has the Limit(int) and LimitOffset(int, int) methods.

Rename some interfaces.
Change the OrderBy() method to return a SelectTerminator<T> object instead of an IEnumerable<T> object. To get the same result as before, you need to add a call to the Execute() method like this: OrderBy(…).Execute().
Change the lifetime of the IEnumerable<T> object returned by SelectTerminator interface methods. It is now only valid as long as the corresponding Query object is valid. To get the same result as before, you must add a call to the ToList() method (e.g., Execute().ToList()).

Fix API documents

Add APIs to execute UPDATE statements

Initial release