what is possible "primitive type" in SSDL

what is possible "primitive type" in SSDL

Postby john wang » Tue 08 Sep 2009 20:51

Hi, there,

Because we support multiple databases with same code, so I need to adjust data type to match different databases.

Now the problem is in Oracle Edmx.

In my CSDL, I changed a specific entity property/column data type from Int64 to Int32, in Oracle database, it links to a ID column with Number(10,0).
The SSDL, the default match type is int64.
Not it complies fine. But it seems I have to change data type in SSDL to something like int32, otherwise when I run it, it will crash when I try to save data.

But the compiler will not accept any names, like Int32, int32, integer, etc, reporting an error like:
Error 40: The Type Int32 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.

When I using Devart to link to our tables, I see it accept data type like “int64, decimal, CHAR, DATE, VARCHAR2…”

My question is what is the possible so called “Primitive type” list it accept? Is it related with Oracle somehow?

Or is it legal to change this data type at all?

Please help. I already run out ideas.
Thanks.
john wang
 
Posts: 3
Joined: Wed 02 Sep 2009 03:48
Location: Houston

Postby AndreyR » Wed 16 Sep 2009 08:18

Please take a look at this post:
http://www.devart.com/forums/viewtopic.php?t=15604
It contains the list of primitive types and some mapping clarification.
You can change the SSDL type of the column manually, but take into account the table I gave you the link for.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby john wang » Wed 16 Sep 2009 17:15

Thanks. This is very helpful.
john wang
 
Posts: 3
Joined: Wed 02 Sep 2009 03:48
Location: Houston


Return to dotConnect for Oracle