{"action":"created","issue":{"url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/2","labels_url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/2/comments","events_url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/2/events","html_url":"https://github.com/lanwin/sqlite-net-compactframework/issues/2","id":125985278,"number":2,"title":"NotSupportedException","user":{"login":"limitfly","id":622445,"avatar_url":"https://avatars.githubusercontent.com/u/622445?v=3","gravatar_id":"","url":"https://api.github.com/users/limitfly","html_url":"https://github.com/limitfly","followers_url":"https://api.github.com/users/limitfly/followers","following_url":"https://api.github.com/users/limitfly/following{/other_user}","gists_url":"https://api.github.com/users/limitfly/gists{/gist_id}","starred_url":"https://api.github.com/users/limitfly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/limitfly/subscriptions","organizations_url":"https://api.github.com/users/limitfly/orgs","repos_url":"https://api.github.com/users/limitfly/repos","events_url":"https://api.github.com/users/limitfly/events{/privacy}","received_events_url":"https://api.github.com/users/limitfly/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-01-11T16:39:15Z","updated_at":"2016-01-11T17:16:11Z","closed_at":"2016-01-11T17:04:54Z","body":"Exception:\"notsupportedException\"\r\nSQLite.SQLite3.ColumnDouble(IntPtr stmt, Int32 index)\r\nSQLite.SQLiteCommand.ReadCol(IntPtr stmt, Int32 index, ColType type, Type clrType)\r\nSQLite.SQLiteCommand.ExecuteQuery[T](TableMapping map)\r\nSQLite.SQLiteCommand.ExecuteQuery[T]()\r\nSQLite.TableQuery`1.GetEnumerator()\r\n\r\ntest entity:\r\n\r\n    public class EntityStock\r\n    {\r\n        [PrimaryKey, AutoIncrement]\r\n        public int Id { get; set; }\r\n        [MaxLength( 8 )]\r\n        public string Symbol { get; set; }\r\n\r\n        public override string ToString( ) {return Symbol;   }\r\n    }\r\n\r\n    public class EntityValuation\r\n    {\r\n        [PrimaryKey, AutoIncrement]\r\n        public int Id { get; set; }\r\n        [Indexed]\r\n        public int StockId { get; set; }\r\n        public DateTime Time { get; set; }\r\n        public double Price { get; set; }\r\n\r\n        public override string ToString( )\r\n        {\r\n            return string.Format( \"{0:yyyy-MM-dd} {1:C}\", Time, Price );\r\n        }\r\n    }\r\n\r\ntest method:\r\n\r\n    private void GetStock( string stockSymbol )\r\n    {\r\n        var stock = _db.QueryStock( stockSymbol );\r\n        foreach ( var v in _db.QueryValuations( stock ) )\r\n        {\r\n            lbx.Items.Add( \"   \" + v.ToString( ) );\r\n        }\r\n    }\r\n\r\n    public IEnumerable<EntityValuation> QueryValuations( EntityStock stock )\r\n    {\r\n        return Table<EntityValuation>( ).Where( x => x.StockId == stock.Id );\r\n    }\r\n\r\nerror in sqlite.cs:\r\n\r\n    public IEnumerator<T> GetEnumerator( )\r\n    {\r\n        return GenerateCommand( ).ExecuteQuery<T>( ).GetEnumerator( );\r\n    }\r\n\r\n    public List<T> ExecuteQuery<T>( ) where T : new( )\r\n    {\r\n        return ExecuteQuery<T>( _conn.GetMapping( typeof( T ) ) );\r\n    }\r\n\r\n    public List<T> ExecuteQuery<T>( TableMapping map ) { }\r\n"},"comment":{"url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/comments/170622906","html_url":"https://github.com/lanwin/sqlite-net-compactframework/issues/2#issuecomment-170622906","issue_url":"https://api.github.com/repos/lanwin/sqlite-net-compactframework/issues/2","id":170622906,"user":{"login":"limitfly","id":622445,"avatar_url":"https://avatars.githubusercontent.com/u/622445?v=3","gravatar_id":"","url":"https://api.github.com/users/limitfly","html_url":"https://github.com/limitfly","followers_url":"https://api.github.com/users/limitfly/followers","following_url":"https://api.github.com/users/limitfly/following{/other_user}","gists_url":"https://api.github.com/users/limitfly/gists{/gist_id}","starred_url":"https://api.github.com/users/limitfly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/limitfly/subscriptions","organizations_url":"https://api.github.com/users/limitfly/orgs","repos_url":"https://api.github.com/users/limitfly/repos","events_url":"https://api.github.com/users/limitfly/events{/privacy}","received_events_url":"https://api.github.com/users/limitfly/received_events","type":"User","site_admin":false},"created_at":"2016-01-11T17:16:11Z","updated_at":"2016-01-11T17:16:11Z","body":"The return type of ColumnDouble (interop) should be void.\r\nUntil I see the \"pull requests\", i took me several hours.\r\nThanks \"escobar5\"."}}