Exemple #1
0
 /// <summary>
 /// 查询数据库返回结果。
 /// </summary>
 /// <param name="converter">对象转换器。</param>
 /// <returns>返回数据列表。</returns>
 public TValue FirstOrDefault <TValue>(Func <DbDataReader, TValue> converter)
 {
     Size = 1;
     if (_fields.Count == 0)
     {
         _fields.Add($"{GetAlias(typeof(TModel))}.*");
     }
     using (var reader = _db.ExecuteReader(_sqlGenerator.Query(this).ToString()))
     {
         if (reader.Read())
         {
             return(converter(reader));
         }
     }
     return(default);
Exemple #2
0
 /// <summary>
 /// 查询实例对象。
 /// </summary>
 /// <param name="commandText">SQL字符串。</param>
 /// <param name="parameters">参数实例对象。</param>
 /// <param name="commandType">命令类型。</param>
 /// <returns>返回数据库读取实例接口。</returns>
 public DbDataReader ExecuteReader(string commandText, object parameters = null, CommandType commandType = CommandType.Text)
 => _executor.ExecuteReader(commandText, parameters, commandType);