/// <summary>
/// Executes the query, and returns the first column of the first row in the result
/// set returned by the query. Additional columns or rows are ignored.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="db"></param>
/// <param name="sprocName">Name of the stored procedure to call.</param>
/// <param name="parameters">An object that contains the properties to add as SQL parameters to the SQL command.</param>
/// <param name="dflt"></param>
/// <returns></returns>
public static T ExecuteScalar <T>(this BaDatabase db, string sprocName, object parameters = null, T dflt = default(T))
{
var cmd = db.PrepareSprocCmd(sprocName, parameters);
return(db.ExecuteScalar(cmd, dflt));
}
/// <summary>
/// Executes the query, and returns the first column of the first row in the result
/// set returned by the query. Additional columns or rows are ignored.
/// </summary>
/// <param name="db"></param>
/// <param name="sprocName">Name of the stored procedure to call.</param>
/// <param name="parameters">An object that contains the properties to add as SQL parameters to the SQL command.</param>
/// <param name="dflt"></param>
/// <returns></returns>
public static object ExecuteScalar(this BaDatabase db, string sprocName, object parameters = null, object dflt = null)
{
var cmd = db.PrepareSprocCmd(sprocName, parameters);
return(db.ExecuteScalar(cmd, dflt));
}