The following example shows how to obtain the primary key that is generated for a newly inserted row. The example uses an
SACommand object to call a SQL stored procedure and an SAParameter object to retrieve the primary key that it returns. For
demonstration purposes, the example creates a sample table (adodotnet_primarykey) and the stored procedure (sp_adodotnet_primarykey)
that will be used to insert rows and return primary key values.