//手写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); }