MaxLength not set to match DB table

tflak · Post by **tflak** » Fri 07 Jan 2011 23:15

I have a table in Oracle that looks like this:

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.

AndreyR · Post by **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 · Post by **AndreyR** » Mon 24 Jan 2011 13:52

We have fixed this problem.
The fix will be available in the nearest build.

AndreyR · Post by **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.