//手写DataReader查询
private static long HandQuery(AdoHelper db, System.Diagnostics.Stopwatch watch)
{
watch.Restart();
string sql = "select UserID, Name, Pwd, RegistedDate from Tb_User1";
IList <UserDto> list = db.ExecuteMapper(sql).MapToList <UserDto>(reader => new UserDto
{
UserID = reader.IsDBNull(0)? default(int): reader.GetInt32(0),
Name = reader.IsDBNull(1) ? default(string) : reader.GetString(1),
Pwd = reader.IsDBNull(2) ? default(string) : reader.GetString(2),
RegistedDate = reader.IsDBNull(3) ? default(DateTime) : reader.GetDateTime(3)
});
watch.Stop();
Console.WriteLine("HandQuery List (100000 item) 耗时：(ms)" + watch.ElapsedMilliseconds);
return(watch.ElapsedMilliseconds);
}
