where子句中的动态列名称.实体框架 [英] Dynamic column name in where clause. Entity Framework

问题描述

我想在我的选择查询中动态放置列名.我该怎么办?

I want to dynamically place column name in my select-query. How I can do this?

public IEnumerable MyTable MySelect(string colName, string param)
{
  using (MyEntities db = new MyEntities ())
  {
     var query = from res in db.MyTable
     where res.colName.Contains(param)
     select res;
     return query;
  }
}

推荐答案

您是否尝试过 res.Field< string>(colName)?

public IEnumerable MySelect(string colName, string param)
{
  using (MyEntities db = new MyEntities ())
  {
     var query = from res in db.MyTable.AsEnumerable()
     where res.Field<string>(colName).Contains(param)
     select res;
     return query;
  }
}

此处是一个示例.

PS:我尚未编译代码，因此可能会出错.

PS: I haven't compiled the code so might give error.

这篇关于where子句中的动态列名称.实体框架的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！