{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2180","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2180/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2180/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2180/events","html_url":"https://github.com/aspnet/EntityFramework/issues/2180","id":76109425,"number":2180,"title":"Generating SQL2012 specific code when using 2008R2","user":{"login":"matthewDDennis","id":8105715,"avatar_url":"https://avatars.githubusercontent.com/u/8105715?v=3","gravatar_id":"","url":"https://api.github.com/users/matthewDDennis","html_url":"https://github.com/matthewDDennis","followers_url":"https://api.github.com/users/matthewDDennis/followers","following_url":"https://api.github.com/users/matthewDDennis/following{/other_user}","gists_url":"https://api.github.com/users/matthewDDennis/gists{/gist_id}","starred_url":"https://api.github.com/users/matthewDDennis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/matthewDDennis/subscriptions","organizations_url":"https://api.github.com/users/matthewDDennis/orgs","repos_url":"https://api.github.com/users/matthewDDennis/repos","events_url":"https://api.github.com/users/matthewDDennis/events{/privacy}","received_events_url":"https://api.github.com/users/matthewDDennis/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/bug","name":"bug","color":"f7c6c7"},{"url":"https://api.github.com/repos/aspnet/EntityFramework/labels/pri0","name":"pri0","color":"e11d21"}],"state":"open","locked":false,"assignee":{"login":"anpete","id":1210944,"avatar_url":"https://avatars.githubusercontent.com/u/1210944?v=3","gravatar_id":"","url":"https://api.github.com/users/anpete","html_url":"https://github.com/anpete","followers_url":"https://api.github.com/users/anpete/followers","following_url":"https://api.github.com/users/anpete/following{/other_user}","gists_url":"https://api.github.com/users/anpete/gists{/gist_id}","starred_url":"https://api.github.com/users/anpete/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/anpete/subscriptions","organizations_url":"https://api.github.com/users/anpete/orgs","repos_url":"https://api.github.com/users/anpete/repos","events_url":"https://api.github.com/users/anpete/events{/privacy}","received_events_url":"https://api.github.com/users/anpete/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7","html_url":"https://github.com/aspnet/EntityFramework/milestones/7.0.0","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/milestones/7/labels","id":666128,"number":7,"title":"7.0.0","description":"","creator":{"login":"rowanmiller","id":4741851,"avatar_url":"https://avatars.githubusercontent.com/u/4741851?v=3","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"open_issues":210,"closed_issues":3,"state":"open","created_at":"2014-05-21T19:25:32Z","updated_at":"2015-08-28T16:33:50Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2015-05-13T20:17:04Z","updated_at":"2015-08-28T17:24:04Z","closed_at":null,"body":"I have a query that has Skip() and Take() calls to implement paging.  The code generated is in the form\r\n```sql\r\nSELECT ...FROM [Article] AS [a]\r\nWHERE [a].[PublishingStatusId] = 2\r\nORDER BY [a].[Updated] DESC OFFSET 0 ROWS FETCH NEXT 25 ROWS ONLY \r\n```\r\nThe OFFSET ...  code is SQL2012+ only."},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/135838677","html_url":"https://github.com/aspnet/EntityFramework/issues/2180#issuecomment-135838677","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2180","id":135838677,"user":{"login":"rowanmiller","id":4741851,"avatar_url":"https://avatars.githubusercontent.com/u/4741851?v=3","gravatar_id":"","url":"https://api.github.com/users/rowanmiller","html_url":"https://github.com/rowanmiller","followers_url":"https://api.github.com/users/rowanmiller/followers","following_url":"https://api.github.com/users/rowanmiller/following{/other_user}","gists_url":"https://api.github.com/users/rowanmiller/gists{/gist_id}","starred_url":"https://api.github.com/users/rowanmiller/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rowanmiller/subscriptions","organizations_url":"https://api.github.com/users/rowanmiller/orgs","repos_url":"https://api.github.com/users/rowanmiller/repos","events_url":"https://api.github.com/users/rowanmiller/events{/privacy}","received_events_url":"https://api.github.com/users/rowanmiller/received_events","type":"User","site_admin":false},"created_at":"2015-08-28T17:24:04Z","updated_at":"2015-08-28T17:24:04Z","body":"I think this one is separate from the test issue. We need a way for folks to be able to run against 2008, at the moment I don't think there is any API surface or internal logic that allows preventing EF from generating OFFSET/FETCH. If it's an explicit API folks need to call, then there is a test component as well to make use of the API."}}