{"action":"created","issue":{"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/872","repository_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator","labels_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/872/labels{/name}","comments_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/872/comments","events_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/872/events","html_url":"https://github.com/fluentmigrator/fluentmigrator/issues/872","id":318858573,"number":872,"title":"How to get the generated SQL script without changing the database","user":{"login":"saeidjoker","id":20520614,"avatar_url":"https://avatars2.githubusercontent.com/u/20520614?v=4","gravatar_id":"","url":"https://api.github.com/users/saeidjoker","html_url":"https://github.com/saeidjoker","followers_url":"https://api.github.com/users/saeidjoker/followers","following_url":"https://api.github.com/users/saeidjoker/following{/other_user}","gists_url":"https://api.github.com/users/saeidjoker/gists{/gist_id}","starred_url":"https://api.github.com/users/saeidjoker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/saeidjoker/subscriptions","organizations_url":"https://api.github.com/users/saeidjoker/orgs","repos_url":"https://api.github.com/users/saeidjoker/repos","events_url":"https://api.github.com/users/saeidjoker/events{/privacy}","received_events_url":"https://api.github.com/users/saeidjoker/received_events","type":"User","site_admin":false},"labels":[{"id":903643769,"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/labels/question","name":"question","color":"96ffe8","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-04-30T11:23:37Z","updated_at":"2018-04-30T11:30:25Z","closed_at":null,"author_association":"NONE","body":"This is more of a QUESTION than issue.\r\nI'm trying to create \"sql queries\" using your AMAZING library.\r\nBut I just want to create sql queries not migrating database. Could you please tell me\r\nhow can I get only the generated sql query for each Migration class at any time?\r\nI wanna use fluentmigrator as a DDL generator only."},"comment":{"url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/comments/385372544","html_url":"https://github.com/fluentmigrator/fluentmigrator/issues/872#issuecomment-385372544","issue_url":"https://api.github.com/repos/fluentmigrator/fluentmigrator/issues/872","id":385372544,"user":{"login":"reinaldocoelho","id":889634,"avatar_url":"https://avatars0.githubusercontent.com/u/889634?v=4","gravatar_id":"","url":"https://api.github.com/users/reinaldocoelho","html_url":"https://github.com/reinaldocoelho","followers_url":"https://api.github.com/users/reinaldocoelho/followers","following_url":"https://api.github.com/users/reinaldocoelho/following{/other_user}","gists_url":"https://api.github.com/users/reinaldocoelho/gists{/gist_id}","starred_url":"https://api.github.com/users/reinaldocoelho/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/reinaldocoelho/subscriptions","organizations_url":"https://api.github.com/users/reinaldocoelho/orgs","repos_url":"https://api.github.com/users/reinaldocoelho/repos","events_url":"https://api.github.com/users/reinaldocoelho/events{/privacy}","received_events_url":"https://api.github.com/users/reinaldocoelho/received_events","type":"User","site_admin":false},"created_at":"2018-04-30T11:30:25Z","updated_at":"2018-04-30T11:30:25Z","author_association":"COLLABORATOR","body":"Hi @saeidjoker .\r\n\r\nTo write a SQL command you can try this:\r\n`            \r\nExecute.Sql(@\"\r\n                UPDATE\r\n\t                t\r\n                SET\r\n\t                t.Field = 'X'\r\n                FROM\r\n\t                table  t\r\n                WHERE\r\n\t                t.Id = 2\r\n\");\r\n`\r\n\r\nIs that your question?\r\nIf not, what type of query you want to run, have you an example?"}}
{"actor":{"display_login":"reinaldocoelho"}}