Telerik OpenAccess Context Extensions

DataReaderExtensions

public static class DataReaderExtensions
{
    public static List<dynamic> ToDynamicList(this IDataReader reader)
    {
        var result = new List<dynamic>();
        while (reader.Read())
        {
            ExpandoObject item = new ExpandoObject();
            var itemDictionary = item as IDictionary<string, object>;
            for (int i = 0; i < reader.FieldCount; i++)
            {
                var key = reader.GetName(i);
                    
                if (!itemDictionary.ContainsKey(key))
                {
                    itemDictionary.Add(key, reader[i]);
                }
            }
            result.Add(item);
        }
        return result;
    }
}

Dynamic MVC Grid

  <%=Html.Telerik()
           .Grid(Model)
           .Name("dynamicGrid")    
           .Columns(factory => 
                    {
                        var firstItem = Model.FirstOrDefault();
                        if(firstItem != null)
                        {
                            var dict = firstItem as IDictionary<string, dynamic>;

                            if (dict != null)
                            {
                                foreach (var key in dict.Keys)
                                {
                                    factory.Bound(key);
                                }
                            }
                        }
                    })
            .Sortable() %>

gistfile1.txt

public ActionResult Index()
{
    var context = new EntitiesModel();
    IEnumerable<dynamic> customersWithOrders= context.DynamicQuery("SELECT * FROM Customers c LEFT JOIN Orders o ON c.CustomerID = o.CustomerID");

    return View(customersWithOrders);
}

OpenAccessContextExtensions

public static class OpenAccessContextExtensions
{
        public static IEnumerable<dynamic> DynamicQuery(this OpenAccessContext context, string query)
        {
            OAConnection oaConnection = context.Connection;
            using (OACommand oaCommand = oaConnection.CreateCommand())
            {
                oaCommand.CommandType = CommandType.Text;
                oaCommand.CommandText = query;
                using (DbDataReader dataReader = oaCommand.ExecuteReader())
                {
                    return dataReader.ToDynamicList();
                }
            }
        }
}