/// <summary>
/// 使用<see cref="IMapper{T}"/>查询指定对象。
/// SQL命中的记录必须为1行，否则抛出异常。
/// 这是一个异步操作。
/// </summary>
/// <typeparam name="T">查询的目标类型。</typeparam>
/// <param name="mapper"><see cref="IMapper{T}"/>的实例。</param>
/// <param name="sql">查询SQL。</param>
/// <param name="parameters">参数序列。空序列或null表示没有参数。</param>
/// <param name="commandType">命令的类型。</param>
/// <param name="timeout">命令的超时时间，单位毫秒。0表示不指定，此时套用默认的超时设置。</param>
/// <returns>目标类型的实例。</returns>
/// <exception cref="IncorrectResultSizeException">当SQL命中的记录行数不为 1。</exception>
public virtual async Task <T> ForceGetAsync <T>(IMapper <T> mapper,
string sql, IEnumerable <DbParameter> parameters = null,
CommandType commandType = CommandType.Text, int timeout = 0)
{
if (!AsyncEnabled)
{
return(ForceGet(mapper, sql, parameters, commandType, timeout));
}
DbConnection connection = null;
IDataReader reader = null;
DbCommand cmd = null;
try
{
connection = await CreateAndOpenConnectionAsync();
cmd = CreateCommand(sql, connection, parameters, commandType, timeout);
reader = await cmd.ExecuteReaderAsync();
int rowCount;
T result;
if (DbClientHelper.TryMapUniqueRow(reader, mapper, out result, out rowCount))
{
return(result);
}
throw new IncorrectResultSizeException(sql, CommandType.Text, parameters, 1, rowCount);
}
catch (Exception ex)
{
throw new SqlExecutingException(sql, commandType, parameters, ex);
}
finally
{
cmd?.Parameters.Clear();
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (connection != null)
{
CloseConnection(connection);
}
}
}
/// <summary>
/// 使用<see cref="IMapper{T}"/>查询指定对象。
/// SQL命中的记录必须为1行，否则抛出异常。
/// </summary>
/// <typeparam name="T">查询的目标类型。</typeparam>
/// <param name="mapper"><see cref="IMapper{T}"/>的实例。</param>
/// <param name="sql">查询SQL。</param>
/// <param name="parameters">参数序列。空序列或null表示没有参数。</param>
/// <param name="commandType">命令的类型。</param>
/// <param name="timeout">命令的超时时间，单位毫秒。0表示不指定，此时套用默认的超时设置。</param>
/// <returns>目标类型的实例。</returns>
/// <exception cref="IncorrectResultSizeException">当SQL命中的记录行数不为 1。</exception>
public virtual T ForceGet <T>(IMapper <T> mapper,
string sql, IEnumerable <DbParameter> parameters = null,
CommandType commandType = CommandType.Text, int timeout = 0)
{
ArgAssert.NotNullOrEmpty(sql, nameof(sql));
ArgAssert.NotNull(mapper, nameof(mapper));
DbConnection connection = null;
IDataReader reader = null;
DbCommand cmd = null;
try
{
connection = CreateAndOpenConnection();
cmd = CreateCommand(sql, connection, parameters, commandType, timeout);
reader = cmd.ExecuteReader();
int rowCount;
T result;
if (DbClientHelper.TryMapUniqueRow(reader, mapper, out result, out rowCount))
{
return(result);
}
throw new IncorrectResultSizeException(sql, CommandType.Text, parameters, 1, rowCount);
}
catch (Exception ex)
{
throw new SqlExecutingException(sql, commandType, parameters, ex);
}
finally
{
cmd?.Parameters.Clear();
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
if (connection != null)
{
CloseConnection(connection);
}
}
}