{"action":"created","comment":{"url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/comments/42998410","id":42998410,"diff_hunk":"@@ -1,5 +1,12 @@\n <?xml version=\"1.0\" encoding=\"utf-8\"?>\r\n <configuration>\r\n+  <system.data>\r\n+    <DbProviderFactories>\r\n+      <add name=\"Npgsql\" invariant=\"Npgsql\"\r\n+      description=\".Net Framework Data Provider for Postgres\"\r\n+      type=\"Npgsql.NpgsqlFactory, Npgsql, Version=3.0.3.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7\"/>\r\n+    </DbProviderFactories>\r\n+  </system.data>\r","path":"product/roundhouse.console/app.config","position":9,"original_position":9,"commit_id":"c2edf28dba82c1fbe057fefb873bbb2602d4fd2b","original_commit_id":"c2edf28dba82c1fbe057fefb873bbb2602d4fd2b","user":{"login":"drusellers","id":63355,"avatar_url":"https://avatars.githubusercontent.com/u/63355?v=3","gravatar_id":"","url":"https://api.github.com/users/drusellers","html_url":"https://github.com/drusellers","followers_url":"https://api.github.com/users/drusellers/followers","following_url":"https://api.github.com/users/drusellers/following{/other_user}","gists_url":"https://api.github.com/users/drusellers/gists{/gist_id}","starred_url":"https://api.github.com/users/drusellers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drusellers/subscriptions","organizations_url":"https://api.github.com/users/drusellers/orgs","repos_url":"https://api.github.com/users/drusellers/repos","events_url":"https://api.github.com/users/drusellers/events{/privacy}","received_events_url":"https://api.github.com/users/drusellers/received_events","type":"User","site_admin":false},"body":"This is what is required to use https://github.com/chucknorris/roundhouse/blob/master/product/roundhouse/databases/AdoNetDatabase.cs#L31. We are telling `System.Data.DbProviderFactories` that we have a factory called `Npgsql` (which comes from https://github.com/chucknorris/roundhouse/blob/master/product/roundhouse.databases.postgresql/PostgreSQLDatabase.cs#L86). Npgsql implements the required interface.\r\n\r\nTo my knowledge, this would need to be done for all other database types. You can see something similar for MySql here - https://github.com/chucknorris/roundhouse/blob/master/product/roundhouse.databases.mysql/MySqlDatabase.cs#L81\r\n\r\nOracle: https://github.com/chucknorris/roundhouse/blob/master/product/roundhouse.databases.oracle/OracleDatabase.cs#L87\r\n\r\nSome can be registered in the machine config by installers, in this case I'm just adding it for just this application.","created_at":"2015-10-26T14:21:03Z","updated_at":"2015-10-26T14:21:03Z","html_url":"https://github.com/chucknorris/roundhouse/pull/224#discussion_r42998410","pull_request_url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224","_links":{"self":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/comments/42998410"},"html":{"href":"https://github.com/chucknorris/roundhouse/pull/224#discussion_r42998410"},"pull_request":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224"}}},"pull_request":{"url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224","id":48743698,"html_url":"https://github.com/chucknorris/roundhouse/pull/224","diff_url":"https://github.com/chucknorris/roundhouse/pull/224.diff","patch_url":"https://github.com/chucknorris/roundhouse/pull/224.patch","issue_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/224","number":224,"state":"open","locked":false,"title":"Pg enhancements","user":{"login":"drusellers","id":63355,"avatar_url":"https://avatars.githubusercontent.com/u/63355?v=3","gravatar_id":"","url":"https://api.github.com/users/drusellers","html_url":"https://github.com/drusellers","followers_url":"https://api.github.com/users/drusellers/followers","following_url":"https://api.github.com/users/drusellers/following{/other_user}","gists_url":"https://api.github.com/users/drusellers/gists{/gist_id}","starred_url":"https://api.github.com/users/drusellers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drusellers/subscriptions","organizations_url":"https://api.github.com/users/drusellers/orgs","repos_url":"https://api.github.com/users/drusellers/repos","events_url":"https://api.github.com/users/drusellers/events{/privacy}","received_events_url":"https://api.github.com/users/drusellers/received_events","type":"User","site_admin":false},"body":"This is a series of commits that i needed to make postgres work on the Mac OS using Mono.\r\n\r\nCloses #223 ","created_at":"2015-10-26T14:11:51Z","updated_at":"2015-10-26T14:21:03Z","closed_at":null,"merged_at":null,"merge_commit_sha":"8062cad329a83f17ab60a471ba23aecaf35ed6b4","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224/commits","review_comments_url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224/comments","review_comment_url":"https://api.github.com/repos/chucknorris/roundhouse/pulls/comments{/number}","comments_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/224/comments","statuses_url":"https://api.github.com/repos/chucknorris/roundhouse/statuses/c2edf28dba82c1fbe057fefb873bbb2602d4fd2b","head":{"label":"drusellers:pg-enhancements","ref":"pg-enhancements","sha":"c2edf28dba82c1fbe057fefb873bbb2602d4fd2b","user":{"login":"drusellers","id":63355,"avatar_url":"https://avatars.githubusercontent.com/u/63355?v=3","gravatar_id":"","url":"https://api.github.com/users/drusellers","html_url":"https://github.com/drusellers","followers_url":"https://api.github.com/users/drusellers/followers","following_url":"https://api.github.com/users/drusellers/following{/other_user}","gists_url":"https://api.github.com/users/drusellers/gists{/gist_id}","starred_url":"https://api.github.com/users/drusellers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drusellers/subscriptions","organizations_url":"https://api.github.com/users/drusellers/orgs","repos_url":"https://api.github.com/users/drusellers/repos","events_url":"https://api.github.com/users/drusellers/events{/privacy}","received_events_url":"https://api.github.com/users/drusellers/received_events","type":"User","site_admin":false},"repo":{"id":44972115,"name":"roundhouse","full_name":"drusellers/roundhouse","owner":{"login":"drusellers","id":63355,"avatar_url":"https://avatars.githubusercontent.com/u/63355?v=3","gravatar_id":"","url":"https://api.github.com/users/drusellers","html_url":"https://github.com/drusellers","followers_url":"https://api.github.com/users/drusellers/followers","following_url":"https://api.github.com/users/drusellers/following{/other_user}","gists_url":"https://api.github.com/users/drusellers/gists{/gist_id}","starred_url":"https://api.github.com/users/drusellers/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/drusellers/subscriptions","organizations_url":"https://api.github.com/users/drusellers/orgs","repos_url":"https://api.github.com/users/drusellers/repos","events_url":"https://api.github.com/users/drusellers/events{/privacy}","received_events_url":"https://api.github.com/users/drusellers/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/drusellers/roundhouse","description":"RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control","fork":true,"url":"https://api.github.com/repos/drusellers/roundhouse","forks_url":"https://api.github.com/repos/drusellers/roundhouse/forks","keys_url":"https://api.github.com/repos/drusellers/roundhouse/keys{/key_id}","collaborators_url":"https://api.github.com/repos/drusellers/roundhouse/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/drusellers/roundhouse/teams","hooks_url":"https://api.github.com/repos/drusellers/roundhouse/hooks","issue_events_url":"https://api.github.com/repos/drusellers/roundhouse/issues/events{/number}","events_url":"https://api.github.com/repos/drusellers/roundhouse/events","assignees_url":"https://api.github.com/repos/drusellers/roundhouse/assignees{/user}","branches_url":"https://api.github.com/repos/drusellers/roundhouse/branches{/branch}","tags_url":"https://api.github.com/repos/drusellers/roundhouse/tags","blobs_url":"https://api.github.com/repos/drusellers/roundhouse/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/drusellers/roundhouse/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/drusellers/roundhouse/git/refs{/sha}","trees_url":"https://api.github.com/repos/drusellers/roundhouse/git/trees{/sha}","statuses_url":"https://api.github.com/repos/drusellers/roundhouse/statuses/{sha}","languages_url":"https://api.github.com/repos/drusellers/roundhouse/languages","stargazers_url":"https://api.github.com/repos/drusellers/roundhouse/stargazers","contributors_url":"https://api.github.com/repos/drusellers/roundhouse/contributors","subscribers_url":"https://api.github.com/repos/drusellers/roundhouse/subscribers","subscription_url":"https://api.github.com/repos/drusellers/roundhouse/subscription","commits_url":"https://api.github.com/repos/drusellers/roundhouse/commits{/sha}","git_commits_url":"https://api.github.com/repos/drusellers/roundhouse/git/commits{/sha}","comments_url":"https://api.github.com/repos/drusellers/roundhouse/comments{/number}","issue_comment_url":"https://api.github.com/repos/drusellers/roundhouse/issues/comments{/number}","contents_url":"https://api.github.com/repos/drusellers/roundhouse/contents/{+path}","compare_url":"https://api.github.com/repos/drusellers/roundhouse/compare/{base}...{head}","merges_url":"https://api.github.com/repos/drusellers/roundhouse/merges","archive_url":"https://api.github.com/repos/drusellers/roundhouse/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/drusellers/roundhouse/downloads","issues_url":"https://api.github.com/repos/drusellers/roundhouse/issues{/number}","pulls_url":"https://api.github.com/repos/drusellers/roundhouse/pulls{/number}","milestones_url":"https://api.github.com/repos/drusellers/roundhouse/milestones{/number}","notifications_url":"https://api.github.com/repos/drusellers/roundhouse/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/drusellers/roundhouse/labels{/name}","releases_url":"https://api.github.com/repos/drusellers/roundhouse/releases{/id}","created_at":"2015-10-26T14:03:45Z","updated_at":"2015-10-26T14:03:49Z","pushed_at":"2015-10-26T14:11:04Z","git_url":"git://github.com/drusellers/roundhouse.git","ssh_url":"git@github.com:drusellers/roundhouse.git","clone_url":"https://github.com/drusellers/roundhouse.git","svn_url":"https://github.com/drusellers/roundhouse","homepage":"http://projectroundhouse.org","size":77691,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"chucknorris:master","ref":"master","sha":"de4d86a85213553bf025a8cee4b2e6ebdeadf7ed","user":{"login":"chucknorris","id":150006,"avatar_url":"https://avatars.githubusercontent.com/u/150006?v=3","gravatar_id":"","url":"https://api.github.com/users/chucknorris","html_url":"https://github.com/chucknorris","followers_url":"https://api.github.com/users/chucknorris/followers","following_url":"https://api.github.com/users/chucknorris/following{/other_user}","gists_url":"https://api.github.com/users/chucknorris/gists{/gist_id}","starred_url":"https://api.github.com/users/chucknorris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chucknorris/subscriptions","organizations_url":"https://api.github.com/users/chucknorris/orgs","repos_url":"https://api.github.com/users/chucknorris/repos","events_url":"https://api.github.com/users/chucknorris/events{/privacy}","received_events_url":"https://api.github.com/users/chucknorris/received_events","type":"Organization","site_admin":false},"repo":{"id":369782,"name":"roundhouse","full_name":"chucknorris/roundhouse","owner":{"login":"chucknorris","id":150006,"avatar_url":"https://avatars.githubusercontent.com/u/150006?v=3","gravatar_id":"","url":"https://api.github.com/users/chucknorris","html_url":"https://github.com/chucknorris","followers_url":"https://api.github.com/users/chucknorris/followers","following_url":"https://api.github.com/users/chucknorris/following{/other_user}","gists_url":"https://api.github.com/users/chucknorris/gists{/gist_id}","starred_url":"https://api.github.com/users/chucknorris/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chucknorris/subscriptions","organizations_url":"https://api.github.com/users/chucknorris/orgs","repos_url":"https://api.github.com/users/chucknorris/repos","events_url":"https://api.github.com/users/chucknorris/events{/privacy}","received_events_url":"https://api.github.com/users/chucknorris/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/chucknorris/roundhouse","description":"RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control","fork":false,"url":"https://api.github.com/repos/chucknorris/roundhouse","forks_url":"https://api.github.com/repos/chucknorris/roundhouse/forks","keys_url":"https://api.github.com/repos/chucknorris/roundhouse/keys{/key_id}","collaborators_url":"https://api.github.com/repos/chucknorris/roundhouse/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/chucknorris/roundhouse/teams","hooks_url":"https://api.github.com/repos/chucknorris/roundhouse/hooks","issue_events_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/events{/number}","events_url":"https://api.github.com/repos/chucknorris/roundhouse/events","assignees_url":"https://api.github.com/repos/chucknorris/roundhouse/assignees{/user}","branches_url":"https://api.github.com/repos/chucknorris/roundhouse/branches{/branch}","tags_url":"https://api.github.com/repos/chucknorris/roundhouse/tags","blobs_url":"https://api.github.com/repos/chucknorris/roundhouse/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/chucknorris/roundhouse/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/chucknorris/roundhouse/git/refs{/sha}","trees_url":"https://api.github.com/repos/chucknorris/roundhouse/git/trees{/sha}","statuses_url":"https://api.github.com/repos/chucknorris/roundhouse/statuses/{sha}","languages_url":"https://api.github.com/repos/chucknorris/roundhouse/languages","stargazers_url":"https://api.github.com/repos/chucknorris/roundhouse/stargazers","contributors_url":"https://api.github.com/repos/chucknorris/roundhouse/contributors","subscribers_url":"https://api.github.com/repos/chucknorris/roundhouse/subscribers","subscription_url":"https://api.github.com/repos/chucknorris/roundhouse/subscription","commits_url":"https://api.github.com/repos/chucknorris/roundhouse/commits{/sha}","git_commits_url":"https://api.github.com/repos/chucknorris/roundhouse/git/commits{/sha}","comments_url":"https://api.github.com/repos/chucknorris/roundhouse/comments{/number}","issue_comment_url":"https://api.github.com/repos/chucknorris/roundhouse/issues/comments{/number}","contents_url":"https://api.github.com/repos/chucknorris/roundhouse/contents/{+path}","compare_url":"https://api.github.com/repos/chucknorris/roundhouse/compare/{base}...{head}","merges_url":"https://api.github.com/repos/chucknorris/roundhouse/merges","archive_url":"https://api.github.com/repos/chucknorris/roundhouse/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/chucknorris/roundhouse/downloads","issues_url":"https://api.github.com/repos/chucknorris/roundhouse/issues{/number}","pulls_url":"https://api.github.com/repos/chucknorris/roundhouse/pulls{/number}","milestones_url":"https://api.github.com/repos/chucknorris/roundhouse/milestones{/number}","notifications_url":"https://api.github.com/repos/chucknorris/roundhouse/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/chucknorris/roundhouse/labels{/name}","releases_url":"https://api.github.com/repos/chucknorris/roundhouse/releases{/id}","created_at":"2009-11-12T02:54:12Z","updated_at":"2015-10-21T14:12:06Z","pushed_at":"2015-10-26T14:11:51Z","git_url":"git://github.com/chucknorris/roundhouse.git","ssh_url":"git@github.com:chucknorris/roundhouse.git","clone_url":"https://github.com/chucknorris/roundhouse.git","svn_url":"https://github.com/chucknorris/roundhouse","homepage":"http://projectroundhouse.org","size":77691,"stargazers_count":362,"watchers_count":362,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":135,"mirror_url":null,"open_issues_count":82,"forks":135,"open_issues":82,"watchers":362,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224"},"html":{"href":"https://github.com/chucknorris/roundhouse/pull/224"},"issue":{"href":"https://api.github.com/repos/chucknorris/roundhouse/issues/224"},"comments":{"href":"https://api.github.com/repos/chucknorris/roundhouse/issues/224/comments"},"review_comments":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224/comments"},"review_comment":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/chucknorris/roundhouse/pulls/224/commits"},"statuses":{"href":"https://api.github.com/repos/chucknorris/roundhouse/statuses/c2edf28dba82c1fbe057fefb873bbb2602d4fd2b"}}}}