{"action":"created","issue":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4082","repository_url":"https://api.github.com/repos/Starcounter/Starcounter","labels_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4082/labels{/name}","comments_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4082/comments","events_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4082/events","html_url":"https://github.com/Starcounter/Starcounter/issues/4082","id":205516868,"number":4082,"title":"Millions of records iteration.","user":{"login":"SenerDemiral","id":3463333,"avatar_url":"https://avatars.githubusercontent.com/u/3463333?v=3","gravatar_id":"","url":"https://api.github.com/users/SenerDemiral","html_url":"https://github.com/SenerDemiral","followers_url":"https://api.github.com/users/SenerDemiral/followers","following_url":"https://api.github.com/users/SenerDemiral/following{/other_user}","gists_url":"https://api.github.com/users/SenerDemiral/gists{/gist_id}","starred_url":"https://api.github.com/users/SenerDemiral/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SenerDemiral/subscriptions","organizations_url":"https://api.github.com/users/SenerDemiral/orgs","repos_url":"https://api.github.com/users/SenerDemiral/repos","events_url":"https://api.github.com/users/SenerDemiral/events{/privacy}","received_events_url":"https://api.github.com/users/SenerDemiral/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2017-02-06T08:33:10Z","updated_at":"2017-02-06T08:45:49Z","closed_at":null,"body":"Do I have to read all the records and assign to variable to iterate?\r\nas:\r\n```\r\nQueryResultRows<Game> Game = Db.SQL<Game>(\"SELECT g FROM Game g\");\r\nforeach(var g in Game) {\r\n  ...\r\n}\r\n```\r\nor\r\nAre there any alternative way like sequential read one by one?\r\nas:\r\n```\r\nGame.First();\r\ndo {\r\n  ...\r\nwhile(Game.Next)\r\n```"},"comment":{"url":"https://api.github.com/repos/Starcounter/Starcounter/issues/comments/277617037","html_url":"https://github.com/Starcounter/Starcounter/issues/4082#issuecomment-277617037","issue_url":"https://api.github.com/repos/Starcounter/Starcounter/issues/4082","id":277617037,"user":{"login":"k-rus","id":1726044,"avatar_url":"https://avatars.githubusercontent.com/u/1726044?v=3","gravatar_id":"","url":"https://api.github.com/users/k-rus","html_url":"https://github.com/k-rus","followers_url":"https://api.github.com/users/k-rus/followers","following_url":"https://api.github.com/users/k-rus/following{/other_user}","gists_url":"https://api.github.com/users/k-rus/gists{/gist_id}","starred_url":"https://api.github.com/users/k-rus/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/k-rus/subscriptions","organizations_url":"https://api.github.com/users/k-rus/orgs","repos_url":"https://api.github.com/users/k-rus/repos","events_url":"https://api.github.com/users/k-rus/events{/privacy}","received_events_url":"https://api.github.com/users/k-rus/received_events","type":"User","site_admin":false},"created_at":"2017-02-06T08:45:49Z","updated_at":"2017-02-06T08:45:49Z","body":"`foreach` in C# is a syntactical sugaring over `IEnumerable`. The result of calling `Db.SQL` is `IEnumerable`, therefore you can use `MoveNext` and `Current`. Check C# documentation as it is nothing special for Starcounter."}}
{"actor":{"display_login":"k-rus"}}