Page 1 of 1
DbType = DOUBLE problem
Posted: Thu 24 Mar 2011 17:47
by seser
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
Posted: Thu 24 Mar 2011 17:51
by seser
similar to this problem
for function parameters which type is "double"
it generates
Dbtype="double precision"
Posted: Fri 25 Mar 2011 15:07
by StanislavK
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?
Posted: Sat 26 Mar 2011 08:27
by seser
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.
Posted: Tue 29 Mar 2011 17:03
by StanislavK
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.