{"action":"created","issue":{"url":"https://api.github.com/repos/tamasflamich/effort/issues/28","repository_url":"https://api.github.com/repos/tamasflamich/effort","labels_url":"https://api.github.com/repos/tamasflamich/effort/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/tamasflamich/effort/issues/28/comments","events_url":"https://api.github.com/repos/tamasflamich/effort/issues/28/events","html_url":"https://github.com/tamasflamich/effort/issues/28","id":129538191,"number":28,"title":"Effort does not support the SQL standard type Geography (KeyNotFoundException)","user":{"login":"boylec","id":8148174,"avatar_url":"https://avatars.githubusercontent.com/u/8148174?v=3","gravatar_id":"","url":"https://api.github.com/users/boylec","html_url":"https://github.com/boylec","followers_url":"https://api.github.com/users/boylec/followers","following_url":"https://api.github.com/users/boylec/following{/other_user}","gists_url":"https://api.github.com/users/boylec/gists{/gist_id}","starred_url":"https://api.github.com/users/boylec/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/boylec/subscriptions","organizations_url":"https://api.github.com/users/boylec/orgs","repos_url":"https://api.github.com/users/boylec/repos","events_url":"https://api.github.com/users/boylec/events{/privacy}","received_events_url":"https://api.github.com/users/boylec/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":6,"created_at":"2016-01-28T18:36:24Z","updated_at":"2016-04-04T08:40:38Z","closed_at":null,"body":"Throws a KeyNotFoundException when creating a context.\r\n\r\n(reference this post http://forum.aspnetboilerplate.com/viewtopic.php?p=2713)"},"comment":{"url":"https://api.github.com/repos/tamasflamich/effort/issues/comments/205197214","html_url":"https://github.com/tamasflamich/effort/issues/28#issuecomment-205197214","issue_url":"https://api.github.com/repos/tamasflamich/effort/issues/28","id":205197214,"user":{"login":"jimmymain","id":2555050,"avatar_url":"https://avatars.githubusercontent.com/u/2555050?v=3","gravatar_id":"","url":"https://api.github.com/users/jimmymain","html_url":"https://github.com/jimmymain","followers_url":"https://api.github.com/users/jimmymain/followers","following_url":"https://api.github.com/users/jimmymain/following{/other_user}","gists_url":"https://api.github.com/users/jimmymain/gists{/gist_id}","starred_url":"https://api.github.com/users/jimmymain/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimmymain/subscriptions","organizations_url":"https://api.github.com/users/jimmymain/orgs","repos_url":"https://api.github.com/users/jimmymain/repos","events_url":"https://api.github.com/users/jimmymain/events{/privacy}","received_events_url":"https://api.github.com/users/jimmymain/received_events","type":"User","site_admin":false},"created_at":"2016-04-04T08:40:38Z","updated_at":"2016-04-04T08:40:38Z","body":"I have worked around this by adding the following code to OnModelCreating.\r\nIt just ignores storing the property, vaguely useful if you want to write unit tests involving the other fields on your entity, rather than having no tests.\r\n\r\n````\r\n// this horrible hack stops the geolocation from being saved in effort.\r\n// https://github.com/tamasflamich/effort/issues/28\r\nif (this.Database.Connection.GetType().Name.StartsWith(\"Effort\", StringComparison.Ordinal))\r\n    modelBuilder.Entity<Building>().Ignore(_ => _.Geolocation);\r\n```"}}