EF执行SQL返回动态类型

https://www.cnblogs.com/jacle169/p/4949654.html

namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var entity = new ldhEntities())
            {
                var context = ((IObjectContextAdapter)entity).ObjectContext;
                string myQuery = @"select affairinfo.ID, affairinfo.NAME from affairinfo";
                var data = (new ObjectQuery<DbDataRecord>(myQuery, context)).ToList();

                foreach (DbDataRecord rec in data)
                {
                    Console.WriteLine("ID {0}; NAME {1}", rec[0], rec[1]);

                   //Console.WriteLine("ID {0}; NAME {1}", rec["ID"], rec["NAME"]);
                }
            }
            Console.Read();
        }
    }
}

缺点是select语句中不能用”*“，并且字段必须带上表名