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

Requirements

• Visual Studio 2022 (17.9) or .NET 8.0 (8.0.203)

New

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

Changed

• 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()).