ComponentOne ADO.NET DataExtender
C1.C1DataExtender.2 Assembly / C1.C1DataExtender.SchemaExtender Namespace / DataConnectionExtenderBase Class / IdentityColumnLastValueSelect Property

In This Topic
    IdentityColumnLastValueSelect Property
    In This Topic
    Gets or sets a SQL SELECT statement used to retrieve primary key value automatically generated on database server.
    Syntax
    'Declaration
 
Public Property IdentityColumnLastValueSelect As System.String
    public System.string IdentityColumnLastValueSelect {get; set;}
    Remarks
    General explanation of extended connection info is provided in the Connection Information topic.

    In the case of database server type that provides sequence or generator object for autoincrement generation you should use a special mark in the statement definition to define the place for the sequence name: AUTOINCREMENTSEQUENCENAME (or its brief form: %%). If statement contains this mark then it will be substituted with the sequence name specified in the DataTableExtender.AutoIncrementSequenceName property before statement will be passed to server, for example when working against Oracle server:

    SELECT AUTOINCREMENTSEQUENCENAME.CURRVAL FROM DUAL

    See Also

    Reference

    DataConnectionExtenderBase Class
    DataConnectionExtenderBase Members