Exemple #1
0
        public static List <T> ToList <T>(this ExcelReference range, Func <T> factory = null) where T : class
        {
            var items = new List <T>();

            XLObjectMapper.AddRange(items, range.GetValue(), factory);
            return(items);
        }
        /// <summary>
        /// Directly load the the rows from a dbreader into a list of xlobjects
        /// Important: The order of the returned columns must match the one of T column mapping
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="reader"></param>
        /// <returns></returns>
        public static List <T> ToXLObjectList <T>(this DbDataReader reader) where T : class
        {
            var  list = new List <T>();
            Type t    = typeof(T);
            var  map  = XLObjectMapper.GetObjectMapping <T>(null);

            while (reader.Read())
            {
                T instance = (t.GetConstructor(Type.EmptyTypes) != null) ? (T)Activator.CreateInstance(t, new object[0])
                            : Activator.CreateInstance <T>();
                int nFields = reader.FieldCount;

                for (int i = 0; i < nFields; i++)
                {
                    map.SetColumn(instance, i, reader.GetValue(i));
                }
                list.Add(instance);
            }
            return(list);
        }