DbType = DOUBLE problem

seser · Post by **seser** » Thu 24 Mar 2011 17:47

create type some_type (
field1 integer,
field2 varchar(20),
field3 float8
);

creae function some_function()
returns as setof some_type as ....

Entitty develeoper generates code
[Column(Name = @"field3", Storage = "_Field3", DbType = "DOUBLE")]
public System.Nullable Field3

and postgresql does not have type named "double"

entity developer version 3.20.104

seser · Post by **seser** » Thu 24 Mar 2011 17:51

similar to this problem
for function parameters which type is "double"
it generates
Dbtype="double precision"

StanislavK · Post by **StanislavK** » Fri 25 Mar 2011 15:07

Thank you for the report, we have reproduced the problem with the complex type. We will inform you when it is fixed.

As for the second issue, do you mean that you've added a method with a System.Double parameter to the model, and mapping synchronization set the DbType property of this parameter to 'double precision'? This is the expected behaviour; if you are encountering any problems with it, could you please descrive them in details?

seser · Post by **seser** » Sat 26 Mar 2011 08:27

this not couse error. but I want to see a consistency in code generation.
for all other double types generated code like 'DbType="FLOAT8"', so why this is different.

StanislavK · Post by **StanislavK** » Tue 29 Mar 2011 17:03

Could you please describe the situation in more details? I.e., please specify
- the exact way you've added a double parameter to the function;
- at which moment did the 'double precision' server type appeared;
- what were the situations when the 'float8' type was generated instead.

JIC: 'float8' and 'double precision' are synonyms and represent the same PostgreSQL data type.