如何通过在ASP.NET MVC5中动态传递多个列名来获取记录 [英] How to get records by passing multiple column names dynamically in ASP.NET MVC5

问题描述

通过传递单列名称绑定记录但我想通过使用实体框架动态传递多个列名来获取记录



我尝试过：

by passing single column name binding records but i want to get records by passing multiple column names dynamically using entity framework

What I have tried:

public List<string> GetRecords(List<string> Columns,string tablename)
    {
        using (var Context = new MCPEntities())
        {
             string columnnames = string.Join(",", Columns);
            var Records = Context.Database.SqlQuery<string>("SELECT " + columnnames + " FROM " + tablename + " ").ToList();
            return Records.ToList();
        }
    }

推荐答案

数据阅读器有多个领域。多个字段对EDM原语或枚举类型无效 - Google搜索 [ ^ ]



请在提问前做基础研究。

The data reader has more than one field. Multiple fields are not valid for EDM primitive or enumeration types - Google Search[^]

Please do basic research before asking a question.

这篇关于如何通过在ASP.NET MVC5中动态传递多个列名来获取记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！