Created row id

[steve]

Is it possible to get the primary key back from an insert? I tried with these approaches:

dbManager.Insert(company, out long companyID);

But this gives -1 rather than the generated id. The insert method also returns an int, but presumably this is rows affected.

Thanks

[echo17]

You could run a query after the insert:

SELECT MAX(companyID) AS companyID FROM company