/// <summary>
/// 将结果集转换为指定的数据类型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns>List<T>.</returns>
/// <remarks>
/// <para>创建：Teddy</para>
/// <para>日期：2018/3/22</para>
/// </remarks>
public List <T> ToList <T>()
where T : class
{
List <T> retObjs = new List <T>();
var drToObjectMapper = new DataReaderToObjectMapper <T>();
using (IDataReader reader = this.ToDataReader())
{
if (reader == null)
{
return(retObjs);
}
var list = new List <T>();
while (reader.Read())
{
list.Add(drToObjectMapper.ConvertObject(reader));
}
retObjs = list;
reader.Close();
}
return(retObjs);
}
/// <summary>
/// To the object.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns>T.</returns>
/// <remarks>
/// <para>创建：Teddy</para>
/// <para>日期：2018/3/22</para>
/// </remarks>
public T ToObject <T>()
where T : class
{
T retObj = default(T);
var drToObjectMapper = new DataReaderToObjectMapper <T>();
using (IDataReader reader = this.ToDataReader())
{
if (reader.Read())
{
retObj = drToObjectMapper.ConvertObject(reader);
}
}
return(retObj);
}
/// <summary>
/// 用于返回自定义的数据结构
/// </summary>
/// <typeparam name="TResult"></typeparam>
/// <returns></returns>
/// <remarks>
/// var result = [...].ToList<Type1>();
/// result[0].P1 result[0].P2 返回的结果为Type1对象
/// </remarks>
public List <TResult> ToList <TResult>() where TResult : class
{
List <TResult> retObjs = new List <TResult>();
var drToObjectMapper = new DataReaderToObjectMapper <TResult>();
using (IDataReader reader = this.ToDataReader())
{
if (reader == null)
{
return(retObjs);
}
while (reader.Read())
{
retObjs.Add(drToObjectMapper.ConvertObject(reader));
}
reader.Close();
}
return(retObjs);
}
