How to retrieve a single value from the database using Dapper
<p>I'm using Dapper and trying to retrieve a short from the database and would like to do this without grabbing it from a collection.</p>

<p>I've got the following code, which doesn't work because <code>QueryAsync&lt;short&gt;</code> returns <code>IEnumerable&lt;short&gt;</code>.</p>

<pre><code>short status;
using (var sqlConnection = new SqlConnection(connectionString))
{
    var parameters = new DynamicParameters();
    parameters.Add("@ID", ID, DbType.Int32, ParameterDirection.Input);

    await sqlConnection.OpenAsync();
    status = await sqlConnection.QueryAsync&lt;short&gt;("SELECT [StatusID] FROM [MyTable] WHERE [ID] = @ID", parameters, commandTimeout: _sqlCommandTimeoutInSeconds);
}
</code></pre>

<p>Can I get Dapper to return a single value, instead of a collection?</p>