MaxLength not set to match DB table

MaxLength not set to match DB table

Postby tflak » Fri 07 Jan 2011 23:15

I have a table in Oracle that looks like this:

Code: Select all
CREATE TABLE "MIL"."EO_ORDER"
   (   "EO_ORDERID" NUMBER(38,0) NOT NULL ENABLE,
   "EO_ORDERTYPEID" NUMBER(38,0) NOT NULL ENABLE,
   "SECONDARYTYPE" VARCHAR2(255 CHAR),
   "EXTERNALORDERID" VARCHAR2(255 CHAR),
   "EXTERNALCOMMENT" VARCHAR2(4000 BYTE),
   "USERNAME_REQUESTEDBY" VARCHAR2(255 CHAR) NOT NULL ENABLE,
   "USERNAME_REQUESTEDFOR" VARCHAR2(255 CHAR),
   "CREATETIME" DATE DEFAULT SYSDATE,
   "TIMEOUT" DATE,
   "TIMEOUTACTION" VARCHAR2(255 CHAR),
   "TEMPLATE" NUMBER(1,0) DEFAULT 0,
   "ORDER_VALID" NUMBER(1,0) DEFAULT NULL,
   "TRANSLATION_COMMENT" VARCHAR2(200 BYTE),
                 ...


I am using VS 2010, Entity Framework 4, the Microsoft tool "ADO.NET Entity Data Model Designer". When I select "Update Model from Database..", the values of the MaxLength for the VARCHAR columns are not correct (except one column *is* correct!). Here is a view of the SSDL section for this entity:


Code: Select all
     
         
           
         

         
         
         
         
         
         
         
         
         
         
         
         
         
       



Do you know why the MaxLength values do not match the DB table? -- except for the TRANSLATION_COMMENT, which is correct at 200.
tflak
 
Posts: 1
Joined: Fri 07 Jan 2011 23:03

Postby AndreyR » Tue 11 Jan 2011 14:59

This is an issue of Unicode servers.
We are investigating the problem.
I will let you know about the results of our investigation.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Mon 24 Jan 2011 13:52

We have fixed this problem.
The fix will be available in the nearest build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Fri 04 Feb 2011 09:46

The new build of dotConnect for Oracle 6.10.96 is available.
It can be downloaded from here (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to this announcement.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle