{"action":"created","issue":{"url":"https://api.github.com/repos/linq2db/linq2db/issues/537","repository_url":"https://api.github.com/repos/linq2db/linq2db","labels_url":"https://api.github.com/repos/linq2db/linq2db/issues/537/labels{/name}","comments_url":"https://api.github.com/repos/linq2db/linq2db/issues/537/comments","events_url":"https://api.github.com/repos/linq2db/linq2db/issues/537/events","html_url":"https://github.com/linq2db/linq2db/issues/537","id":203769789,"number":537,"title":"Agnostic parameter re-write for execute and query","user":{"login":"ronnyek","id":584713,"avatar_url":"https://avatars.githubusercontent.com/u/584713?v=3","gravatar_id":"","url":"https://api.github.com/users/ronnyek","html_url":"https://github.com/ronnyek","followers_url":"https://api.github.com/users/ronnyek/followers","following_url":"https://api.github.com/users/ronnyek/following{/other_user}","gists_url":"https://api.github.com/users/ronnyek/gists{/gist_id}","starred_url":"https://api.github.com/users/ronnyek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ronnyek/subscriptions","organizations_url":"https://api.github.com/users/ronnyek/orgs","repos_url":"https://api.github.com/users/ronnyek/repos","events_url":"https://api.github.com/users/ronnyek/events{/privacy}","received_events_url":"https://api.github.com/users/ronnyek/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2017-01-28T00:00:31Z","updated_at":"2017-02-03T10:31:54Z","closed_at":null,"body":"I have a few places where I calculate some stats and currently return them in many groups, but not to be mapped to an entity.\r\n\r\nCurrently I do something like .Query<long>(sql, parameters).\r\n\r\nOracle and probably many of the other database vendors have their own notation for the parameter format. My question is whether or not it makes sense to say across the board @param gets rewritten to :param or whatever sort of transform is required via the data provider.\r\n\r\nAlso, I noticed that it seems to want to setup the parameter like so:\r\n```\r\nDECLARE @param Type\r\nSET @param = some value\r\n<sql...> where name = @param\r\n```\r\nI'm guessing this is erroneous since this doesnt even come close to working in oracle."},"comment":{"url":"https://api.github.com/repos/linq2db/linq2db/issues/comments/277215308","html_url":"https://github.com/linq2db/linq2db/issues/537#issuecomment-277215308","issue_url":"https://api.github.com/repos/linq2db/linq2db/issues/537","id":277215308,"user":{"login":"ili","id":787292,"avatar_url":"https://avatars.githubusercontent.com/u/787292?v=3","gravatar_id":"","url":"https://api.github.com/users/ili","html_url":"https://github.com/ili","followers_url":"https://api.github.com/users/ili/followers","following_url":"https://api.github.com/users/ili/following{/other_user}","gists_url":"https://api.github.com/users/ili/gists{/gist_id}","starred_url":"https://api.github.com/users/ili/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ili/subscriptions","organizations_url":"https://api.github.com/users/ili/orgs","repos_url":"https://api.github.com/users/ili/repos","events_url":"https://api.github.com/users/ili/events{/privacy}","received_events_url":"https://api.github.com/users/ili/received_events","type":"User","site_admin":false},"created_at":"2017-02-03T10:31:54Z","updated_at":"2017-02-03T10:31:54Z","body":"@sdanyliv certainly this should work :)\r\n\r\nMy idea was: if you are targeting few databases raw SQL statements should be managed manually."}}
{"actor":{"display_login":"ili"}}