/// <summary> /// 查询单个实体 /// </summary> /// <typeparam name="T">返回的实体集合类型</typeparam> /// <param name="sql">要执行的查询语句</param> /// <param name="parameters">执行SQL查询语句所需要的参数</param> /// <param name="commandType">执行的SQL语句的类型</param> /// <returns></returns> public T QueryForObject<T>(string sql, Dictionary<string, object> parameters, CommandType commandType) where T : new() { DataTable data = ExecuteDataTable(sql, parameters, commandType); return EntityReader.GetEntities<T>(data)[0]; }
/// <summary> /// 查询多个实体集合 /// </summary> /// <typeparam name="T">返回的实体集合类型</typeparam> /// <param name="sql">要执行的查询语句</param> /// <param name="parameters">执行SQL查询语句所需要的参数</param> /// <param name="commandType">执行的SQL语句的类型</param> /// <returns></returns> public List<T> QueryForList<T>(string sql, Dictionary<string, object> parameters, out int total, CommandType commandType) where T : new() { DataTable data = ExecuteDataTable(sql, parameters, commandType); total = data.MinimumCapacity; return EntityReader.GetEntities<T>(data); }