Database Component hxj. Data (26) (Oracle configuration)

The providername of the connectionstrings node configured in Oracle is system. Data. oracleclient or hxj. Data. Oracle. Other operations are similar.

However, it is different from the auto-growth column in Oracle, so we need to handle it as appropriate.

Oracle obtains the Growth Value Through sequence, which is different from SQL Server's ease of setting column auto-growth.

 

You can modify the generated entity to set the auto-increment column.

For example:

A sequence named mysequence is created.

The auto-increment field in the table is kid.

Add the following two methods to the generated object to complete the auto-increment Field Processing of oracle.

Public override stringGetsequence (){Return"Mysequence";}Public overrideFieldGetidentityfield (){Return_. Kid ;}

 

In this way, the auto-increment value is returned after the insert operation.

 

PS: the new version of the entity generation tool fixes some features and adds the option of uppercase letters. Download