search

ssteenkiste / nettiers

Automatically exported from code.google.com/p/nettiers
1 stars 0 forks source link

How can I set the Oracle Number Column to int datatype #386

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi:
   I'm working at Oracle 11g, I need a Auto Increment column in a table, and I add a ID column, set the column data type to Number or Integer. But the property of the Class in the generated solution, the data type is decimal, and I want the property data type is int, How can I do that?
   Thanks.
  Edward

Original issue reported on code.google.com by Rising...@gmail.com on 17 May 2011 at 4:11

GoogleCodeExporter commented 9 years ago 
Hello,

I'm merging this case into 382, as I feel that case 382 will resolve the Auto 
Increment column issue. Once the svn patch is applied, you will need to set a 
boolean extended properties on each Identity Column (CS_IsIdentity) with a 
value of true. 

I believe the patch also contains a CommonSqlCode.cs patch for the GetAlias 
method which handles how column datatypes are handled. You would want to take a 
look at this method and make any changes for how the Oracle DataTypes are 
handled. Otherwise, if you could try using the Mapping rename functionality 
that is described in the documentation.

Please let me know if you have any questions.

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 18 May 2011 at 5:54

GoogleCodeExporter commented 9 years ago 
Hi Blake,
    the point is how can I set the data type of a column to int?
 Thanks
   Edward

Original comment by Rising...@gmail.com on 20 May 2011 at 2:48

GoogleCodeExporter commented 9 years ago 
Hello,

The following guide will walk you through this process 
(http://code.google.com/p/nettiers/issues/detail?id=379&q=oracle%20number&colspe
c=ID%20Type%20Milestone%20Platform%20Status%20Stars%20Priority%20Owner%20Summary
)

Thanks
-Blake Niemyjski

Original comment by bniemyjski on 4 Jul 2011 at 9:29