{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2920","labels_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2920/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2920/comments","events_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2920/events","html_url":"https://github.com/aspnet/EntityFramework/issues/2920","id":103076753,"number":2920,"title":"Migrations generates unnecessary AlterColumn operation for SQLite","user":{"login":"natemcmaster","id":2696087,"avatar_url":"https://avatars.githubusercontent.com/u/2696087?v=3","gravatar_id":"","url":"https://api.github.com/users/natemcmaster","html_url":"https://github.com/natemcmaster","followers_url":"https://api.github.com/users/natemcmaster/followers","following_url":"https://api.github.com/users/natemcmaster/following{/other_user}","gists_url":"https://api.github.com/users/natemcmaster/gists{/gist_id}","starred_url":"https://api.github.com/users/natemcmaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/natemcmaster/subscriptions","organizations_url":"https://api.github.com/users/natemcmaster/orgs","repos_url":"https://api.github.com/users/natemcmaster/repos","events_url":"https://api.github.com/users/natemcmaster/events{/privacy}","received_events_url":"https://api.github.com/users/natemcmaster/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-08-25T17:27:41Z","updated_at":"2015-08-25T19:11:04Z","closed_at":"2015-08-25T19:11:04Z","body":"Creating a new migration for a SQLite context will produce unnecessary AlterColumn operations even though the code definition has not changed.\r\n\r\n**Repro**\r\n\r\n1. Clone the code from https://github.com/aspnet/EntityFramework.Docs/tree/master/docs/getting-started/x-plat/sample\r\n1. Using dnx 1.0.0-beta6, run `dnu restore`\r\n1. `dnx . ef migration add ShouldBeBlankMigration`\r\n\r\n**Expected**\r\nShould generate an empty migration as nothing has changed\r\n\r\n**Actual**\r\nIt produces a migration with alter column operations\r\n```c#\r\n...\r\n public override void Up(MigrationBuilder migration)\r\n        {\r\n            migration.AlterColumn(\r\n                name: \"PostId\",\r\n                table: \"Post\",\r\n                type: \"INTEGER\",\r\n                nullable: false)\r\n                .Annotation(\"Sqlite:Autoincrement\", true);\r\n            migration.AlterColumn(\r\n                name: \"BlogId\",\r\n                table: \"Blog\",\r\n                type: \"INTEGER\",\r\n                nullable: false)\r\n                .Annotation(\"Sqlite:Autoincrement\", true);\r\n        }\r\n...\r\n```"},"comment":{"url":"https://api.github.com/repos/aspnet/EntityFramework/issues/comments/134704870","html_url":"https://github.com/aspnet/EntityFramework/issues/2920#issuecomment-134704870","issue_url":"https://api.github.com/repos/aspnet/EntityFramework/issues/2920","id":134704870,"user":{"login":"natemcmaster","id":2696087,"avatar_url":"https://avatars.githubusercontent.com/u/2696087?v=3","gravatar_id":"","url":"https://api.github.com/users/natemcmaster","html_url":"https://github.com/natemcmaster","followers_url":"https://api.github.com/users/natemcmaster/followers","following_url":"https://api.github.com/users/natemcmaster/following{/other_user}","gists_url":"https://api.github.com/users/natemcmaster/gists{/gist_id}","starred_url":"https://api.github.com/users/natemcmaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/natemcmaster/subscriptions","organizations_url":"https://api.github.com/users/natemcmaster/orgs","repos_url":"https://api.github.com/users/natemcmaster/repos","events_url":"https://api.github.com/users/natemcmaster/events{/privacy}","received_events_url":"https://api.github.com/users/natemcmaster/received_events","type":"User","site_admin":false},"created_at":"2015-08-25T19:11:04Z","updated_at":"2015-08-25T19:11:04Z","body":"Ah yup. Just tested on newer bits. "}}