{"action":"created","comment":{"url":"https://api.github.com/repos/Azure/azure-powershell/pulls/comments/175952730","pull_request_review_id":105571493,"id":175952730,"diff_hunk":"@@ -379,23 +493,34 @@ internal AzureSqlDeletedDatabaseBackupModel GetDeletedDatabaseBackup(string reso\n         /// <returns>Restored database object</returns>\n         internal AzureSqlDatabaseModel RestoreDatabase(string resourceGroup, DateTime restorePointInTime, string resourceId, AzureSqlDatabaseModel model)\n         {\n-            DatabaseCreateOrUpdateParameters parameters = new DatabaseCreateOrUpdateParameters()\n+            if (model.CreateMode.Equals(\"RestoreLongTermRetentionBackup\") && CultureInfo.CurrentCulture.CompareInfo.IndexOf(resourceId, \"/providers/Microsoft.Sql\", CompareOptions.IgnoreCase) >= 0)","path":"src/ResourceManager/Sql/Commands.Sql/Database Backup/Services/AzureSqlDatabaseBackupAdapter.cs","position":225,"original_position":225,"commit_id":"52427ebb2ab1e9cdbf85dca5ad7e2beaa6e2dc1b","original_commit_id":"52427ebb2ab1e9cdbf85dca5ad7e2beaa6e2dc1b","user":{"login":"jaredmoo","id":3248887,"avatar_url":"https://avatars0.githubusercontent.com/u/3248887?v=4","gravatar_id":"","url":"https://api.github.com/users/jaredmoo","html_url":"https://github.com/jaredmoo","followers_url":"https://api.github.com/users/jaredmoo/followers","following_url":"https://api.github.com/users/jaredmoo/following{/other_user}","gists_url":"https://api.github.com/users/jaredmoo/gists{/gist_id}","starred_url":"https://api.github.com/users/jaredmoo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaredmoo/subscriptions","organizations_url":"https://api.github.com/users/jaredmoo/orgs","repos_url":"https://api.github.com/users/jaredmoo/repos","events_url":"https://api.github.com/users/jaredmoo/events{/privacy}","received_events_url":"https://api.github.com/users/jaredmoo/received_events","type":"User","site_admin":false},"body":" `OrdinalIgnoreCase`  is the right comparison to use","created_at":"2018-03-20T23:23:21Z","updated_at":"2018-03-20T23:37:25Z","html_url":"https://github.com/Azure/azure-powershell/pull/5770#discussion_r175952730","pull_request_url":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770","author_association":"MEMBER","_links":{"self":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/comments/175952730"},"html":{"href":"https://github.com/Azure/azure-powershell/pull/5770#discussion_r175952730"},"pull_request":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770"}}},"pull_request":{"url":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770","id":176097236,"html_url":"https://github.com/Azure/azure-powershell/pull/5770","diff_url":"https://github.com/Azure/azure-powershell/pull/5770.diff","patch_url":"https://github.com/Azure/azure-powershell/pull/5770.patch","issue_url":"https://api.github.com/repos/Azure/azure-powershell/issues/5770","number":5770,"state":"open","locked":false,"title":"LTR V2 Powershell cmdlets","user":{"login":"trgrie","id":22154957,"avatar_url":"https://avatars1.githubusercontent.com/u/22154957?v=4","gravatar_id":"","url":"https://api.github.com/users/trgrie","html_url":"https://github.com/trgrie","followers_url":"https://api.github.com/users/trgrie/followers","following_url":"https://api.github.com/users/trgrie/following{/other_user}","gists_url":"https://api.github.com/users/trgrie/gists{/gist_id}","starred_url":"https://api.github.com/users/trgrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trgrie/subscriptions","organizations_url":"https://api.github.com/users/trgrie/orgs","repos_url":"https://api.github.com/users/trgrie/repos","events_url":"https://api.github.com/users/trgrie/events{/privacy}","received_events_url":"https://api.github.com/users/trgrie/received_events","type":"User","site_admin":false},"body":"<!-- DO NOT DELETE THIS TEMPLATE -->\r\n\r\n## Description\r\n<!-- Please add a brief description of the changes made in this PR -->\r\nAdded cmdlets for getting and removing long term retention backups. Updated the cmdlets for getting and setting long term retention policies to work for LTR V2. Updated the Restore-AzureRmSqlDatabase cmdlet to work with LTR V2 resource IDs.\r\n## Checklist\r\n\r\n- [x] I have read the [_Submitting Changes_](https://github.com/Azure/azure-powershell/blob/preview/CONTRIBUTING.md#making-changes) section of [`CONTRIBUTING.md`](https://github.com/Azure/azure-powershell/blob/preview/CONTRIBUTING.md)\r\n- [x] The title of the PR is clear and informative\r\n- [x] The appropriate [change log has been updated](https://github.com/Azure/azure-powershell/blob/preview/CONTRIBUTING.md#updating-the-change-log)\r\n- [x] The PR does not introduce [breaking changes](https://github.com/Azure/azure-powershell/blob/preview/documentation/breaking-changes/breaking-changes-definition.md)\r\n- [x] If applicable, the changes made in the PR have proper test coverage\r\n- [x] For public API changes to cmdlets:\r\n    - [x] the changes have gone through a [cmdlet design review](https://github.com/Azure/azure-powershell-cmdlet-review-pr)\r\n    - [x] the cmdlet markdown files were [generated using the `platyPS` module](https://github.com/Azure/azure-powershell/blob/preview/documentation/development-docs/help-generation.md)","created_at":"2018-03-20T06:11:02Z","updated_at":"2018-03-20T23:37:25Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6941a8d1c2c6c40e92022b6311ec611876208076","assignee":{"login":"trgrie","id":22154957,"avatar_url":"https://avatars1.githubusercontent.com/u/22154957?v=4","gravatar_id":"","url":"https://api.github.com/users/trgrie","html_url":"https://github.com/trgrie","followers_url":"https://api.github.com/users/trgrie/followers","following_url":"https://api.github.com/users/trgrie/following{/other_user}","gists_url":"https://api.github.com/users/trgrie/gists{/gist_id}","starred_url":"https://api.github.com/users/trgrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trgrie/subscriptions","organizations_url":"https://api.github.com/users/trgrie/orgs","repos_url":"https://api.github.com/users/trgrie/repos","events_url":"https://api.github.com/users/trgrie/events{/privacy}","received_events_url":"https://api.github.com/users/trgrie/received_events","type":"User","site_admin":false},"assignees":[{"login":"trgrie","id":22154957,"avatar_url":"https://avatars1.githubusercontent.com/u/22154957?v=4","gravatar_id":"","url":"https://api.github.com/users/trgrie","html_url":"https://github.com/trgrie","followers_url":"https://api.github.com/users/trgrie/followers","following_url":"https://api.github.com/users/trgrie/following{/other_user}","gists_url":"https://api.github.com/users/trgrie/gists{/gist_id}","starred_url":"https://api.github.com/users/trgrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trgrie/subscriptions","organizations_url":"https://api.github.com/users/trgrie/orgs","repos_url":"https://api.github.com/users/trgrie/repos","events_url":"https://api.github.com/users/trgrie/events{/privacy}","received_events_url":"https://api.github.com/users/trgrie/received_events","type":"User","site_admin":false}],"requested_reviewers":[{"login":"cormacpayne","id":4462409,"avatar_url":"https://avatars2.githubusercontent.com/u/4462409?v=4","gravatar_id":"","url":"https://api.github.com/users/cormacpayne","html_url":"https://github.com/cormacpayne","followers_url":"https://api.github.com/users/cormacpayne/followers","following_url":"https://api.github.com/users/cormacpayne/following{/other_user}","gists_url":"https://api.github.com/users/cormacpayne/gists{/gist_id}","starred_url":"https://api.github.com/users/cormacpayne/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cormacpayne/subscriptions","organizations_url":"https://api.github.com/users/cormacpayne/orgs","repos_url":"https://api.github.com/users/cormacpayne/repos","events_url":"https://api.github.com/users/cormacpayne/events{/privacy}","received_events_url":"https://api.github.com/users/cormacpayne/received_events","type":"User","site_admin":false},{"login":"hchungmsft","id":17032746,"avatar_url":"https://avatars0.githubusercontent.com/u/17032746?v=4","gravatar_id":"","url":"https://api.github.com/users/hchungmsft","html_url":"https://github.com/hchungmsft","followers_url":"https://api.github.com/users/hchungmsft/followers","following_url":"https://api.github.com/users/hchungmsft/following{/other_user}","gists_url":"https://api.github.com/users/hchungmsft/gists{/gist_id}","starred_url":"https://api.github.com/users/hchungmsft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hchungmsft/subscriptions","organizations_url":"https://api.github.com/users/hchungmsft/orgs","repos_url":"https://api.github.com/users/hchungmsft/repos","events_url":"https://api.github.com/users/hchungmsft/events{/privacy}","received_events_url":"https://api.github.com/users/hchungmsft/received_events","type":"User","site_admin":false}],"requested_teams":[],"labels":[{"id":556235223,"url":"https://api.github.com/repos/Azure/azure-powershell/labels/needs-revision","name":"needs-revision","color":"fd8c00","default":false}],"milestone":null,"commits_url":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770/commits","review_comments_url":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770/comments","review_comment_url":"https://api.github.com/repos/Azure/azure-powershell/pulls/comments{/number}","comments_url":"https://api.github.com/repos/Azure/azure-powershell/issues/5770/comments","statuses_url":"https://api.github.com/repos/Azure/azure-powershell/statuses/52427ebb2ab1e9cdbf85dca5ad7e2beaa6e2dc1b","head":{"label":"trgrie:preview","ref":"preview","sha":"52427ebb2ab1e9cdbf85dca5ad7e2beaa6e2dc1b","user":{"login":"trgrie","id":22154957,"avatar_url":"https://avatars1.githubusercontent.com/u/22154957?v=4","gravatar_id":"","url":"https://api.github.com/users/trgrie","html_url":"https://github.com/trgrie","followers_url":"https://api.github.com/users/trgrie/followers","following_url":"https://api.github.com/users/trgrie/following{/other_user}","gists_url":"https://api.github.com/users/trgrie/gists{/gist_id}","starred_url":"https://api.github.com/users/trgrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trgrie/subscriptions","organizations_url":"https://api.github.com/users/trgrie/orgs","repos_url":"https://api.github.com/users/trgrie/repos","events_url":"https://api.github.com/users/trgrie/events{/privacy}","received_events_url":"https://api.github.com/users/trgrie/received_events","type":"User","site_admin":false},"repo":{"id":103435967,"name":"azure-powershell","full_name":"trgrie/azure-powershell","owner":{"login":"trgrie","id":22154957,"avatar_url":"https://avatars1.githubusercontent.com/u/22154957?v=4","gravatar_id":"","url":"https://api.github.com/users/trgrie","html_url":"https://github.com/trgrie","followers_url":"https://api.github.com/users/trgrie/followers","following_url":"https://api.github.com/users/trgrie/following{/other_user}","gists_url":"https://api.github.com/users/trgrie/gists{/gist_id}","starred_url":"https://api.github.com/users/trgrie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/trgrie/subscriptions","organizations_url":"https://api.github.com/users/trgrie/orgs","repos_url":"https://api.github.com/users/trgrie/repos","events_url":"https://api.github.com/users/trgrie/events{/privacy}","received_events_url":"https://api.github.com/users/trgrie/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/trgrie/azure-powershell","description":"Microsoft Azure PowerShell","fork":true,"url":"https://api.github.com/repos/trgrie/azure-powershell","forks_url":"https://api.github.com/repos/trgrie/azure-powershell/forks","keys_url":"https://api.github.com/repos/trgrie/azure-powershell/keys{/key_id}","collaborators_url":"https://api.github.com/repos/trgrie/azure-powershell/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/trgrie/azure-powershell/teams","hooks_url":"https://api.github.com/repos/trgrie/azure-powershell/hooks","issue_events_url":"https://api.github.com/repos/trgrie/azure-powershell/issues/events{/number}","events_url":"https://api.github.com/repos/trgrie/azure-powershell/events","assignees_url":"https://api.github.com/repos/trgrie/azure-powershell/assignees{/user}","branches_url":"https://api.github.com/repos/trgrie/azure-powershell/branches{/branch}","tags_url":"https://api.github.com/repos/trgrie/azure-powershell/tags","blobs_url":"https://api.github.com/repos/trgrie/azure-powershell/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/trgrie/azure-powershell/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/trgrie/azure-powershell/git/refs{/sha}","trees_url":"https://api.github.com/repos/trgrie/azure-powershell/git/trees{/sha}","statuses_url":"https://api.github.com/repos/trgrie/azure-powershell/statuses/{sha}","languages_url":"https://api.github.com/repos/trgrie/azure-powershell/languages","stargazers_url":"https://api.github.com/repos/trgrie/azure-powershell/stargazers","contributors_url":"https://api.github.com/repos/trgrie/azure-powershell/contributors","subscribers_url":"https://api.github.com/repos/trgrie/azure-powershell/subscribers","subscription_url":"https://api.github.com/repos/trgrie/azure-powershell/subscription","commits_url":"https://api.github.com/repos/trgrie/azure-powershell/commits{/sha}","git_commits_url":"https://api.github.com/repos/trgrie/azure-powershell/git/commits{/sha}","comments_url":"https://api.github.com/repos/trgrie/azure-powershell/comments{/number}","issue_comment_url":"https://api.github.com/repos/trgrie/azure-powershell/issues/comments{/number}","contents_url":"https://api.github.com/repos/trgrie/azure-powershell/contents/{+path}","compare_url":"https://api.github.com/repos/trgrie/azure-powershell/compare/{base}...{head}","merges_url":"https://api.github.com/repos/trgrie/azure-powershell/merges","archive_url":"https://api.github.com/repos/trgrie/azure-powershell/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/trgrie/azure-powershell/downloads","issues_url":"https://api.github.com/repos/trgrie/azure-powershell/issues{/number}","pulls_url":"https://api.github.com/repos/trgrie/azure-powershell/pulls{/number}","milestones_url":"https://api.github.com/repos/trgrie/azure-powershell/milestones{/number}","notifications_url":"https://api.github.com/repos/trgrie/azure-powershell/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/trgrie/azure-powershell/labels{/name}","releases_url":"https://api.github.com/repos/trgrie/azure-powershell/releases{/id}","deployments_url":"https://api.github.com/repos/trgrie/azure-powershell/deployments","created_at":"2017-09-13T18:27:15Z","updated_at":"2018-03-20T22:10:54Z","pushed_at":"2018-03-20T22:10:52Z","git_url":"git://github.com/trgrie/azure-powershell.git","ssh_url":"git@github.com:trgrie/azure-powershell.git","clone_url":"https://github.com/trgrie/azure-powershell.git","svn_url":"https://github.com/trgrie/azure-powershell","homepage":null,"size":372711,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"preview"}},"base":{"label":"Azure:preview","ref":"preview","sha":"6a893ee381667adc9f4dc71a5e38187a390358ff","user":{"login":"Azure","id":6844498,"avatar_url":"https://avatars0.githubusercontent.com/u/6844498?v=4","gravatar_id":"","url":"https://api.github.com/users/Azure","html_url":"https://github.com/Azure","followers_url":"https://api.github.com/users/Azure/followers","following_url":"https://api.github.com/users/Azure/following{/other_user}","gists_url":"https://api.github.com/users/Azure/gists{/gist_id}","starred_url":"https://api.github.com/users/Azure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Azure/subscriptions","organizations_url":"https://api.github.com/users/Azure/orgs","repos_url":"https://api.github.com/users/Azure/repos","events_url":"https://api.github.com/users/Azure/events{/privacy}","received_events_url":"https://api.github.com/users/Azure/received_events","type":"Organization","site_admin":false},"repo":{"id":23891194,"name":"azure-powershell","full_name":"Azure/azure-powershell","owner":{"login":"Azure","id":6844498,"avatar_url":"https://avatars0.githubusercontent.com/u/6844498?v=4","gravatar_id":"","url":"https://api.github.com/users/Azure","html_url":"https://github.com/Azure","followers_url":"https://api.github.com/users/Azure/followers","following_url":"https://api.github.com/users/Azure/following{/other_user}","gists_url":"https://api.github.com/users/Azure/gists{/gist_id}","starred_url":"https://api.github.com/users/Azure/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Azure/subscriptions","organizations_url":"https://api.github.com/users/Azure/orgs","repos_url":"https://api.github.com/users/Azure/repos","events_url":"https://api.github.com/users/Azure/events{/privacy}","received_events_url":"https://api.github.com/users/Azure/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/Azure/azure-powershell","description":"Microsoft Azure PowerShell","fork":false,"url":"https://api.github.com/repos/Azure/azure-powershell","forks_url":"https://api.github.com/repos/Azure/azure-powershell/forks","keys_url":"https://api.github.com/repos/Azure/azure-powershell/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Azure/azure-powershell/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Azure/azure-powershell/teams","hooks_url":"https://api.github.com/repos/Azure/azure-powershell/hooks","issue_events_url":"https://api.github.com/repos/Azure/azure-powershell/issues/events{/number}","events_url":"https://api.github.com/repos/Azure/azure-powershell/events","assignees_url":"https://api.github.com/repos/Azure/azure-powershell/assignees{/user}","branches_url":"https://api.github.com/repos/Azure/azure-powershell/branches{/branch}","tags_url":"https://api.github.com/repos/Azure/azure-powershell/tags","blobs_url":"https://api.github.com/repos/Azure/azure-powershell/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Azure/azure-powershell/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Azure/azure-powershell/git/refs{/sha}","trees_url":"https://api.github.com/repos/Azure/azure-powershell/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Azure/azure-powershell/statuses/{sha}","languages_url":"https://api.github.com/repos/Azure/azure-powershell/languages","stargazers_url":"https://api.github.com/repos/Azure/azure-powershell/stargazers","contributors_url":"https://api.github.com/repos/Azure/azure-powershell/contributors","subscribers_url":"https://api.github.com/repos/Azure/azure-powershell/subscribers","subscription_url":"https://api.github.com/repos/Azure/azure-powershell/subscription","commits_url":"https://api.github.com/repos/Azure/azure-powershell/commits{/sha}","git_commits_url":"https://api.github.com/repos/Azure/azure-powershell/git/commits{/sha}","comments_url":"https://api.github.com/repos/Azure/azure-powershell/comments{/number}","issue_comment_url":"https://api.github.com/repos/Azure/azure-powershell/issues/comments{/number}","contents_url":"https://api.github.com/repos/Azure/azure-powershell/contents/{+path}","compare_url":"https://api.github.com/repos/Azure/azure-powershell/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Azure/azure-powershell/merges","archive_url":"https://api.github.com/repos/Azure/azure-powershell/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Azure/azure-powershell/downloads","issues_url":"https://api.github.com/repos/Azure/azure-powershell/issues{/number}","pulls_url":"https://api.github.com/repos/Azure/azure-powershell/pulls{/number}","milestones_url":"https://api.github.com/repos/Azure/azure-powershell/milestones{/number}","notifications_url":"https://api.github.com/repos/Azure/azure-powershell/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Azure/azure-powershell/labels{/name}","releases_url":"https://api.github.com/repos/Azure/azure-powershell/releases{/id}","deployments_url":"https://api.github.com/repos/Azure/azure-powershell/deployments","created_at":"2014-09-10T20:35:18Z","updated_at":"2018-03-20T19:38:04Z","pushed_at":"2018-03-20T23:16:39Z","git_url":"git://github.com/Azure/azure-powershell.git","ssh_url":"git@github.com:Azure/azure-powershell.git","clone_url":"https://github.com/Azure/azure-powershell.git","svn_url":"https://github.com/Azure/azure-powershell","homepage":null,"size":376202,"stargazers_count":947,"watchers_count":947,"language":"C#","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":989,"mirror_url":null,"archived":false,"open_issues_count":652,"license":{"key":"other","name":"Other","spdx_id":null,"url":null},"forks":989,"open_issues":652,"watchers":947,"default_branch":"preview"}},"_links":{"self":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770"},"html":{"href":"https://github.com/Azure/azure-powershell/pull/5770"},"issue":{"href":"https://api.github.com/repos/Azure/azure-powershell/issues/5770"},"comments":{"href":"https://api.github.com/repos/Azure/azure-powershell/issues/5770/comments"},"review_comments":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770/comments"},"review_comment":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/Azure/azure-powershell/pulls/5770/commits"},"statuses":{"href":"https://api.github.com/repos/Azure/azure-powershell/statuses/52427ebb2ab1e9cdbf85dca5ad7e2beaa6e2dc1b"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"jaredmoo"}}