This is a migrated thread and some comments may be shown as answers.

PostgreSQL Mapping with custom types

6 Answers 150 Views
Data Access Free Edition
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Sebastian SWC
Top achievements
Rank 1
Sebastian SWC asked on 17 Jan 2011, 12:04 AM
Hy, sorry for my poor english.

I'm trying to use OpenAcess with PostgreSQL. My database have just only a table with a custom type.

Table definition:
CREATE TABLE test
(
  id serial NOT NULL,
  myarray integer[],
  mycontrol custom_control,
  CONSTRAINT test_pk PRIMARY KEY (id)
);

My custom_control Definition:
CREATE TYPE custom_control
AS (
    dt_modify timestamp without time zone,
    obs character varying(50)
);

After create a new domain model and try to see the table table on a radgrid, the following error occours:

Server Error in '/' Application.

No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Telerik.OpenAccess.Exceptions.MetadataException: No database type mapping found for field '_myarray': CLR type 'System.Object' or column type '_int4' unmapped. 

Any idea what i have to do to solve this problem?

6 Answers, 1 is accepted

Sort by
0
Sebastian SWC
Top achievements
Rank 1
answered on 17 Jan 2011, 12:07 AM
I uploaded the project with the related problem in my website. 
0
Damyan Bogoev
Telerik team
answered on 18 Jan 2011, 06:25 PM
Hi Sebastian SWC,

It seems that there is an issue when PostgreSql user defined types are used in Telerik OpenAccess ORM. We will investigate the cause for this problem and fix it.
Once we resolve the problem we will provide you with details regarding the wrong behavior.
I am sorry for the inconvenience caused.

All the best,
Damyan Bogoev
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Sebastian SWC
Top achievements
Rank 1
answered on 18 Jan 2011, 09:35 PM
Hey,

Don't forget the array types with problem too.

Thanks for your support.
0
Damyan Bogoev
Telerik team
answered on 20 Jan 2011, 06:46 PM
Hi Sebastian SWC,

We will do our best to implement this feature for the next Q1 release.
Once again I am sorry for the inconvenience caused.

Kind regards,
Damyan Bogoev
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Sebastian SWC
Top achievements
Rank 1
answered on 27 May 2011, 06:33 PM
Hi,

any news about that?

Thanks
0
Damyan Bogoev
Telerik team
answered on 31 May 2011, 05:23 PM
Hi Sebastian SWC,

I am afraid that currently we do not provide support for PostgreSql user-defined types in the product.
I am sorry for the inconvenience caused.

All the best,
Damyan Bogoev
the Telerik team
Want to use Telerik OpenAccess with SQL Azure? Download the trial version today. 
Tags
Data Access Free Edition
Asked by
Sebastian SWC
Top achievements
Rank 1
Answers by
Sebastian SWC
Top achievements
Rank 1
Damyan Bogoev
Telerik team
Share this question
or