{"action":"reopened","issue":{"url":"https://api.github.com/repos/zzzprojects/EntityFramework-Effort/issues/104","repository_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Effort","labels_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Effort/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Effort/issues/104/comments","events_url":"https://api.github.com/repos/zzzprojects/EntityFramework-Effort/issues/104/events","html_url":"https://github.com/zzzprojects/EntityFramework-Effort/issues/104","id":303920812,"node_id":"MDU6SXNzdWUzMDM5MjA4MTI=","number":104,"title":"The store type 'smallint' could not be found in the Effort provider manifest","user":{"login":"jimbolla","id":1851364,"node_id":"MDQ6VXNlcjE4NTEzNjQ=","avatar_url":"https://avatars2.githubusercontent.com/u/1851364?v=4","gravatar_id":"","url":"https://api.github.com/users/jimbolla","html_url":"https://github.com/jimbolla","followers_url":"https://api.github.com/users/jimbolla/followers","following_url":"https://api.github.com/users/jimbolla/following{/other_user}","gists_url":"https://api.github.com/users/jimbolla/gists{/gist_id}","starred_url":"https://api.github.com/users/jimbolla/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jimbolla/subscriptions","organizations_url":"https://api.github.com/users/jimbolla/orgs","repos_url":"https://api.github.com/users/jimbolla/repos","events_url":"https://api.github.com/users/jimbolla/events{/privacy}","received_events_url":"https://api.github.com/users/jimbolla/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"JonathanMagnan","id":23240780,"node_id":"MDQ6VXNlcjIzMjQwNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/23240780?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanMagnan","html_url":"https://github.com/JonathanMagnan","followers_url":"https://api.github.com/users/JonathanMagnan/followers","following_url":"https://api.github.com/users/JonathanMagnan/following{/other_user}","gists_url":"https://api.github.com/users/JonathanMagnan/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanMagnan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanMagnan/subscriptions","organizations_url":"https://api.github.com/users/JonathanMagnan/orgs","repos_url":"https://api.github.com/users/JonathanMagnan/repos","events_url":"https://api.github.com/users/JonathanMagnan/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanMagnan/received_events","type":"User","site_admin":false},"assignees":[{"login":"JonathanMagnan","id":23240780,"node_id":"MDQ6VXNlcjIzMjQwNzgw","avatar_url":"https://avatars0.githubusercontent.com/u/23240780?v=4","gravatar_id":"","url":"https://api.github.com/users/JonathanMagnan","html_url":"https://github.com/JonathanMagnan","followers_url":"https://api.github.com/users/JonathanMagnan/followers","following_url":"https://api.github.com/users/JonathanMagnan/following{/other_user}","gists_url":"https://api.github.com/users/JonathanMagnan/gists{/gist_id}","starred_url":"https://api.github.com/users/JonathanMagnan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/JonathanMagnan/subscriptions","organizations_url":"https://api.github.com/users/JonathanMagnan/orgs","repos_url":"https://api.github.com/users/JonathanMagnan/repos","events_url":"https://api.github.com/users/JonathanMagnan/events{/privacy}","received_events_url":"https://api.github.com/users/JonathanMagnan/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2018-03-09T17:35:14Z","updated_at":"2018-06-14T13:47:55Z","closed_at":null,"author_association":"NONE","body":"Our EF Context is generated with EntityFramework Reverse POCO Generator. It has Property mappings that look like:\r\n```\r\nProperty(x => x.BaseDirectoryId).HasColumnName(@\"BaseDirectoryId\").HasColumnType(\"smallint\").IsRequired()\r\n```\r\n\r\nWhen trying to use it with Effort like so:\r\n``` \r\nusing (var connection = DbConnectionFactory.CreatePersistent(\"test\"))\r\nusing (var db = new OurAppDb(connection, true))\r\n{\r\n    // ...\r\n}\r\n```\r\n\r\nWe get: `System.InvalidOperationException The store type 'smallint' could not be found in the Effort provider manifest`\r\n\r\nIf I manually replace the SQL column types with the .NET types like so:\r\n\r\nbigint -> int64\r\nbit -> boolean\r\nchar -> string\r\nfloat -> double\r\nnumeric -> decimal\r\nnvarchar -> string\r\nsmallint -> int16\r\ntinyint -> bye\r\nuniqueidentifier -> guid\r\nvarchar -> string\r\nvarchar(max) -> string\r\n\r\nThen Effort seems to work. But AFAICT, the underlying database type is the proper value to store in the mappings. Would it be possible to get Effort to support these types?\r\n"}}
{"actor":{"display_login":"JonathanMagnan"}}