/// <summary>
 ///     Execute SQL that selects a single value.
 /// </summary>
 /// <typeparam name="T"></typeparam>
 /// <param name="fullSql">The SQL to execute for this Query</param>
 /// <returns>
 ///     The first cell selected as <see cref="object" />.
 /// </returns>
 public async Task <T> ExecuteScalarAsync <T>(string fullSql) => await ExecuteInternalAsync(() =>
                                                                                            SharedConnection.ExecuteScalarAsync <T>(fullSql, null, _transaction,
                                                                                                                                    OneTimeCommandTimeout ?? CommandTimeout));
Exemple #2
0
 /// <summary>
 ///     Execute SQL that checks if record(s) exist.
 /// </summary>
 /// <param name="fullSql">The SQL to execute.</param>
 /// <param name="parameters">The parameters to use for this query.</param>
 /// <returns>
 ///     True if record is found.
 /// </returns>
 public async Task <bool> ExistsAsync(string fullSql, object parameters) => await ExecuteInternalAsync(() =>
                                                                                                       SharedConnection.ExecuteScalarAsync <bool>(fullSql, parameters, _transaction,
                                                                                                                                                  OneTimeCommandTimeout ?? CommandTimeout));