{"action":"created","issue":{"url":"https://api.github.com/repos/volkanceylan/Serenity/issues/128","labels_url":"https://api.github.com/repos/volkanceylan/Serenity/issues/128/labels{/name}","comments_url":"https://api.github.com/repos/volkanceylan/Serenity/issues/128/comments","events_url":"https://api.github.com/repos/volkanceylan/Serenity/issues/128/events","html_url":"https://github.com/volkanceylan/Serenity/issues/128","id":127437486,"number":128,"title":"How to used stored procedure for complex database logic","user":{"login":"laxmanp","id":15955425,"avatar_url":"https://avatars.githubusercontent.com/u/15955425?v=3","gravatar_id":"","url":"https://api.github.com/users/laxmanp","html_url":"https://github.com/laxmanp","followers_url":"https://api.github.com/users/laxmanp/followers","following_url":"https://api.github.com/users/laxmanp/following{/other_user}","gists_url":"https://api.github.com/users/laxmanp/gists{/gist_id}","starred_url":"https://api.github.com/users/laxmanp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/laxmanp/subscriptions","organizations_url":"https://api.github.com/users/laxmanp/orgs","repos_url":"https://api.github.com/users/laxmanp/repos","events_url":"https://api.github.com/users/laxmanp/events{/privacy}","received_events_url":"https://api.github.com/users/laxmanp/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2016-01-19T12:41:48Z","updated_at":"2016-02-01T20:56:05Z","closed_at":"2016-01-21T11:33:02Z","body":"Hello sir,\r\n\r\nI want to used stored procedure for complex database logic. How to call stored procedure by passing some parameters to stored procedure and get data in the form of list or table.\r\n\r\nHow to achieve it."},"comment":{"url":"https://api.github.com/repos/volkanceylan/Serenity/issues/comments/178185209","html_url":"https://github.com/volkanceylan/Serenity/issues/128#issuecomment-178185209","issue_url":"https://api.github.com/repos/volkanceylan/Serenity/issues/128","id":178185209,"user":{"login":"VictorTomaili","id":2023440,"avatar_url":"https://avatars.githubusercontent.com/u/2023440?v=3","gravatar_id":"","url":"https://api.github.com/users/VictorTomaili","html_url":"https://github.com/VictorTomaili","followers_url":"https://api.github.com/users/VictorTomaili/followers","following_url":"https://api.github.com/users/VictorTomaili/following{/other_user}","gists_url":"https://api.github.com/users/VictorTomaili/gists{/gist_id}","starred_url":"https://api.github.com/users/VictorTomaili/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/VictorTomaili/subscriptions","organizations_url":"https://api.github.com/users/VictorTomaili/orgs","repos_url":"https://api.github.com/users/VictorTomaili/repos","events_url":"https://api.github.com/users/VictorTomaili/events{/privacy}","received_events_url":"https://api.github.com/users/VictorTomaili/received_events","type":"User","site_admin":false},"created_at":"2016-02-01T20:56:05Z","updated_at":"2016-02-01T20:56:05Z","body":"Its use defaultly MyRow Databases connectionstring. Its writed on MyRow as attribute. If you want to create new one try this\r\n`using (var customConnection = SqlConnections.NewByKey(\"ConnectionKey\")){ ... }`"}}