namespace GetDataTest
{
    public class SqlDirect
    {
        private static void GetDataBindExtracted(out SqlDataReader reader)
        {
            reader = SqlHelper.ExecuteReader(SqlConfigHelper.SqlContext(), CommandType.Text, "select Id,TestValue from dbo.Test", null);
        }
        /// <summary>
        /// 直接读取（强类型转换）
        /// </summary>
        public static TimeSpan GetDataBindOnParse()
        {
            List<TextCode> list = new List<TextCode>(); ;
            SqlDataReader reader;
            GetDataBindExtracted(out reader);
            Stopwatch watch = new Stopwatch();
            watch.Start();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    TextCode code = new TextCode { Id = Guid.Parse(reader["Id"].ToString()), TestValue = DateTime.Parse(reader["TestValue"].ToString()) };
                    list.Add(code);
                }
            }
            return watch.Elapsed;
        }

        /// <summary>
        /// 直接读取（拆箱）
        /// </summary>
        /// <returns></returns>
        public static TimeSpan GetDataBindOnUnbox()
        {
            List<TextCode> list = new List<TextCode>(); ;
            SqlDataReader reader;
            GetDataBindExtracted(out reader);
            Stopwatch watch = new Stopwatch();
            watch.Start();
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    TextCode code = new TextCode { Id = (Guid)reader["Id"], TestValue = (DateTime)reader["TestValue"] };
                    list.Add(code);
                }
            }
            return watch.Elapsed;
        }

        /// <summary>
        /// 反射方式读取
        /// </summary>
        public static TimeSpan GetDataBindOnRef<T>() where T:class,new()
        {
            List<T> list = new List<T>(); ;
            SqlDataReader reader;
            GetDataBindExtracted(out reader);
            Stopwatch watch = new Stopwatch();
            watch.Start();
            while (reader.Read())
            {
                T entity = new T();
                for (int i = 0; i < reader.FieldCount; i++)
                {
                    PropertyInfo proinfo = entity.GetType().GetProperty(reader.GetName(i));
                    proinfo.SetValue(entity, reader.GetValue(i), null);
                }
                list.Add(entity);
            }
            return watch.Elapsed;
        }
    }
}