ComponentOne DataObjects for .NET
AutoIncrementSequenceName Property (Field)

C1.Data.2 Assembly > C1.Data.SchemaObjects Namespace > Field Class : AutoIncrementSequenceName Property
Gets or sets the name of a sequence or generator database object used for autoincrement on the server.
Syntax
'Declaration
 
Public Overridable Property AutoIncrementSequenceName As System.String
public virtual System.string AutoIncrementSequenceName {get; set;}
Remarks
This property is used to enable autoincrement key field functionality in Oracle, InterBase and other databases that support special database objects used to generate unique (autoincrementing) values. With SQL Server, Access and Sybase, the autoincrement (identity) is assigned automatically by the database and can be retrieved with a special SQL command, see the SqlDialectInfo.IdentityColumnLastValueSelect property. In Oracle and Interbase, setting the key value is not done automatically by the database. It can be done either automatically by C1DataObjects, if you set SqlDialectInfo.IdentityColumnRetrieveMode = BeforeInsertCommand, or by a trigger, in which case you set IdentityColumnRetrieveMode = AfterInsertCommand. In both cases, in addition to setting the IdentityColumnLastValueSelect property that retrieves the autoincremented value, you must set the AutoIncrementSequenceName property to the name of the object generating the value, a sequence in Oracle, a generator in Interbase.
See Also

Reference

Field Class
Field Members
Table Fields
Keys Assigned by Server or Database
IdentityColumnLastValueSelect Property