Convert SQL Datareader to List<T> C#

DatareaderToList

public List<T> Query<T>(string query) where T:new()
        {
            List<T> res = new List<T>(); 
            MySqlCommand q = new MySqlCommand(query, this.db);
            MySqlDataReader r = q.ExecuteReader();
            while (r.Read())
            {
                T t = new T();

                for (int inc = 0; inc < r.FieldCount; inc++)
                {
                    Type type = t.GetType();
                    PropertyInfo prop = type.GetProperty(r.GetName(inc));
                    prop.SetValue(t, r.GetValue(inc), null);
                }

                res.Add(t); 
            }
            r.Close();

            return res; 
            
        }

One small enhancement on line 14:

prop.SetValue(t, Convert.ChangeType(r.GetValue(inc), prop.PropertyType), null);

It will prevent System.ArgumentException for properties of different types