{"action":"created","issue":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/807","repository_url":"https://api.github.com/repos/npgsql/npgsql","labels_url":"https://api.github.com/repos/npgsql/npgsql/issues/807/labels{/name}","comments_url":"https://api.github.com/repos/npgsql/npgsql/issues/807/comments","events_url":"https://api.github.com/repos/npgsql/npgsql/issues/807/events","html_url":"https://github.com/npgsql/npgsql/issues/807","id":108859154,"number":807,"title":"Npgsql 3.0.3 and postgis geometry types.","user":{"login":"TheMidgardWatcher","id":5805985,"avatar_url":"https://avatars.githubusercontent.com/u/5805985?v=3","gravatar_id":"","url":"https://api.github.com/users/TheMidgardWatcher","html_url":"https://github.com/TheMidgardWatcher","followers_url":"https://api.github.com/users/TheMidgardWatcher/followers","following_url":"https://api.github.com/users/TheMidgardWatcher/following{/other_user}","gists_url":"https://api.github.com/users/TheMidgardWatcher/gists{/gist_id}","starred_url":"https://api.github.com/users/TheMidgardWatcher/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/TheMidgardWatcher/subscriptions","organizations_url":"https://api.github.com/users/TheMidgardWatcher/orgs","repos_url":"https://api.github.com/users/TheMidgardWatcher/repos","events_url":"https://api.github.com/users/TheMidgardWatcher/events{/privacy}","received_events_url":"https://api.github.com/users/TheMidgardWatcher/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":8,"created_at":"2015-09-29T12:29:20Z","updated_at":"2016-08-02T07:36:54Z","closed_at":"2015-09-29T14:57:46Z","body":"Hi!\r\n\r\nWe are using some geometry in our project (PostgreSQL 9.4 + postgis 2.1.8 + LLBLGEN 4.2).\r\nWhen we used Npgsql 2.2.x version, we are worked with geometry fields as 'text' but after update to 3.0.x version npgsql has begun to throwing not supported exceptions:\r\n\r\nStack trace:\r\n```c#\r\nSystem.NotSupportedException\r\n\r\nThe field Geom has a type currently unknown to Npgsql (OID 189889). You can retrieve it as a string by marking it as unknown, please see the FAQ.\r\n\r\nin Npgsql.NpgsqlDataReader.GetValue(Int32 ordinal)\r\nin Npgsql.NpgsqlDataReader.GetValues(Object[] values)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.EntityMaterializerBase.Materialize(Func`4 valueReadErrorHandler, String& failureErrorText)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, ITransaction containingTransaction, IEntityCollection collectionToFill, Boolean allowDuplicates, IEntityFields fieldsUsedForQuery, IFieldPersistenceInfo[] fieldPersistenceInfos)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformGetMultiAction(ITransaction containingTransaction, QueryParameters parameters)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.GetMulti(ITransaction containingTransaction, IEntityFactory entityFactoryToUse, QueryParameters parameters)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.EntityCollectionBase`1.PerformGetMulti(QueryParameters parameters)\r\nin SD.LLBLGen.Pro.ORMSupportClasses.EntityCollectionBase`1.GetMulti(IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relations, IPrefetchPath prefetchPathToUse, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize)\r\n```\r\nTable which we fetching looks like:\r\n```sql\r\nCREATE TABLE public.geom_table\r\n(\r\n    id bigint NOT NULL DEFAULT new_id() PRIMARY KEY,\r\n    name text,\r\n    latitude double precision,\r\n    longitude double precision,\r\n    model text,\r\n    geom geometry(Point,4326),\r\n    created timestamp without time zone NOT NULL DEFAULT utcnow(),\r\n    modified timestamp without time zone NOT NULL DEFAULT utcnow(),\r\n)\r\n```"},"comment":{"url":"https://api.github.com/repos/npgsql/npgsql/issues/comments/236825653","html_url":"https://github.com/npgsql/npgsql/issues/807#issuecomment-236825653","issue_url":"https://api.github.com/repos/npgsql/npgsql/issues/807","id":236825653,"user":{"login":"roji","id":1862641,"avatar_url":"https://avatars.githubusercontent.com/u/1862641?v=3","gravatar_id":"","url":"https://api.github.com/users/roji","html_url":"https://github.com/roji","followers_url":"https://api.github.com/users/roji/followers","following_url":"https://api.github.com/users/roji/following{/other_user}","gists_url":"https://api.github.com/users/roji/gists{/gist_id}","starred_url":"https://api.github.com/users/roji/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/roji/subscriptions","organizations_url":"https://api.github.com/users/roji/orgs","repos_url":"https://api.github.com/users/roji/repos","events_url":"https://api.github.com/users/roji/events{/privacy}","received_events_url":"https://api.github.com/users/roji/received_events","type":"User","site_admin":false},"created_at":"2016-08-02T07:36:53Z","updated_at":"2016-08-02T07:36:53Z","body":"@wolfsnipes, PostGIS is supported at the ADO.NET level, but the EF6 provider doesn't support it yet. The relevant issue is https://github.com/npgsql/EntityFramework6.Npgsql/issues/18. Note that EF Core already supports the PostGIS types.\r\n\r\nIn general, all EF6-related questions/issues belong in https://github.com/npgsql/EntityFramework6.Npgsql."}}
{"actor":{"display_login":"roji"}}