At present we only support returning the primary key value generated by SQL Server, be that an INTEGER, returned with SELECT SCOPE_IDENTITY(), or a UNIQUEIDENTIFIER, using the OUTPUT clause.
It would be helpful if we could return more than one column by using, e.g., a [DbServerGenerated] attribute on properties that are generated by the server and should be returned.
We can use the OUTPUT clause for any column values, including INTEGER primary keys.
The returned values should then be set back on the objects representing the INSERTed rows.