SQL supports ExecuteScalar (SqlCommand.ExecuteScalar Method (System.Data.SqlClient)), which grabs the first row/column from a select, for instance:
to retrieve the last row id.Code:select last_insert_rowid();
This is mostly a convenience method, and since the underlying library already implements it, it might be nice to have.
Request Support for ExecuteScalar with SQL
Discussion in 'Feature Suggestions' started by sqroot, Jun 26, 2016.