{"issue":{"state":"closed","created_at":"2011-11-15T17:04:47Z","updated_at":"2011-11-24T21:02:05Z","user":{"gravatar_id":"e1ec04a74aeffab66e9a5f57b73554a0","id":562854,"url":"https://api.github.com/users/thinkdevcode","login":"thinkdevcode","avatar_url":"https://secure.gravatar.com/avatar/e1ec04a74aeffab66e9a5f57b73554a0?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":2,"body":"Would it be possible to support the TOP sql command?\r\n\r\nEdit: Or even better, have a system for paging results. ","assignee":null,"id":2246430,"labels":[],"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"number":117,"title":"Suggestion: Sql TOP","closed_at":"2011-11-24T21:02:05Z","html_url":"https://github.com/markrendle/Simple.Data/issues/117","url":"https://api.github.com/repos/markrendle/Simple.Data/issues/117","milestone":null},"action":"created","comment":{"created_at":"2011-11-24T21:02:05Z","updated_at":"2011-11-24T21:02:05Z","user":{"gravatar_id":"cc060db2b5331d8cbbfe080cec4add6f","id":178242,"url":"https://api.github.com/users/markrendle","login":"markrendle","avatar_url":"https://secure.gravatar.com/avatar/cc060db2b5331d8cbbfe080cec4add6f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"body":"Since 0.11, SQL Server will use TOP 1 as an optimisation for all single-record queries. As Richard has said, paging is already fully supported using different implementations per provider.","id":2869151,"url":"https://api.github.com/repos/markrendle/Simple.Data/issues/comments/2869151"}}