odp.net : different type mappings

Posts   
 
    
wilmos
User
Posts: 1
Joined: 22-Sep-2008
# Posted on: 22-Sep-2008 11:01:51   

hi we are just trying the latest version of LLBl we are using Oracle 9 , ODP.Net 11.1.0 ;VS2008

after generating some tables there are some different typemapping for the same fields in the entity-class:


public bool FetchUsingPK(System.String teilenr, System.Int16 agnr, System.Int16 agVar, System.Int32 manu) { return FetchUsingPK(teilenr, agnr, agVar, manu, null, null, null);

}

but the agnr is defined as dec:

public virtual System.Decimal Agnr { get { return (System.Decimal)GetValue((int)OpplanVorrichtungFieldIndex.Agnr, true); } set { SetValue((int)OpplanVorrichtungFieldIndex.Agnr, value, true); } }


the agvar to:

public virtual System.Decimal AgVar {


the table looks like :

create table OPPLAN_VORRICHTUNG ( TEILENR VARCHAR2(20) not null, AGNR NUMBER not null, AG_VAR NUMBER not null, MANU NUMBER default 1 not null, VORRICHTUNG VARCHAR2(20) not null, BEMERKUNG VARCHAR2(2000) ) alter table OPPLAN_VORRICHTUNG

add constraint PK_OPPLAN_VORRICHTUNG primary key (TEILENR, AGNR, AG_VAR, MANU, VORRICHTUNG)

thanks for Help Willi

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 22-Sep-2008 16:48:45   

We can't reproduce it.

Would you please attach the lgp project file, and also the db DDL SQL?

Is this the latest ODP.NET (11.1.0.6.20)?