This is a simple example of how to convert an old style ADODB recordset into a dynamic object using the .Net 4.0 dynamic keyword.

This example assumes that you have the ADODB referenced as an Interop.

            public static List<dynamic> AsDynaList(ADODB.Recordset recordset)
            {

                List<dynamic> rs = new List<dynamic>();
                while (!recordset.EOF)
                {
                    var fieldIndex = 0;
                    var test = new ExpandoObject() as IDictionary<string, object>;

                    foreach (ADODB.Field fld in recordset.Fields)
                    {
                        test.Add(fld.Name, recordset.Fields[fieldIndex].Value);
                        fieldIndex++;
                    }
                    rs.Add(test);
                    recordset.MoveNext();
                }
                return rs;
            }