Request Support for ExecuteScalar with SQL

SQL supports ExecuteScalar (SqlCommand.ExecuteScalar Method (System.Data.SqlClient)), which grabs the first row/column from a select, for instance:

Code:

select last_insert_rowid();

to retrieve the last row id.
This is mostly a convenience method, and since the underlying library already implements it, it might be nice to have.

 

Guess what! Solved - MySQL last insert ID | Oxide it will be rejected 100%

 

That's because last_insert_rowid is currently also supported as field, but there are other uses for scalar queries as well.