c# – 动态LINQ查询从数据库获取Field值

发布时间：2020-12-15 04:29:46 所属栏目：百科来源：网络整理

导读：可能吗？ Public String Get_Filed_By_Id(string table_Name,String Field_Name,string PK_val){ string strRes=""; using(mydbcontext db=new mydbcontext()) { var x=db.table_Name.Where(p=p.Id=PK_val).FirstOrDefault().Field_Name; strRes=Convert.Tos

可能吗？

Public String Get_Filed_By_Id(string table_Name,String Field_Name,string PK_val)
{
    string strRes="";
    using(mydbcontext db=new mydbcontext())
    {
      var x=db.table_Name.Where(p=>p.Id=PK_val).FirstOrDefault().Field_Name;
      strRes=Convert.Tostring(x);
    }
 return strRes;
}

要么

var x=(from o in db.table_Name where o.Id=PK_val select o.Field_Name).FirstOrDefault();

在这里,我传递Table_Name,Column_Name和Condition值(PK_val)以在特定条件(Id = Pk_val)内从Table_Name获取Column_Name.

可能吗？？

解决方法

Is it possible??

是的.

首先,一些帮手：

using System;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;

namespace YourNamespace
{
    internal static class DbHelpers
    {
        public static object GetColumnById(this object dbContext,string tableName,string columnName,object id)
        {
            var table = (IQueryable)dbContext.GetType().GetProperty(tableName).GetValue(dbContext,null);
            var row = Expression.Parameter(table.ElementType,"row");
            var filter = Expression.Lambda(Expression.Equal(Expression.Property(row,"Id"),Expression.Constant(id)),row);
            var column = Expression.Property(row,columnName);
            var selector = Expression.Lambda(column,row);
            var query = Call(Where.MakeGenericMethod(row.Type),table,filter);
            query = Call(Select.MakeGenericMethod(row.Type,column.Type),query,selector);
            var value = Call(FirstOrDefault.MakeGenericMethod(column.Type),query);
            return value;
        }
        private static readonly MethodInfo Select = GetGenericMethodDefinition<
            Func<IQueryable<object>,Expression<Func<object,object>>,IQueryable<object>>>((source,selector) =>
            Queryable.Select(source,selector));
        private static readonly MethodInfo Where = GetGenericMethodDefinition<
            Func<IQueryable<object>,bool>>,object>>((source,predicate) =>
            Queryable.Where(source,predicate));
        private static readonly MethodInfo FirstOrDefault = GetGenericMethodDefinition<
            Func<IQueryable<object>,object>>(source =>
            Queryable.FirstOrDefault(source));
        private static MethodInfo GetGenericMethodDefinition<TDelegate>(Expression<TDelegate> e)
        {
            return ((MethodCallExpression)e.Body).Method.GetGenericMethodDefinition();
        }
        private static object Call(MethodInfo method,params object[] parameters)
        {
            return method.Invoke(null,parameters);
        }
    }
}

现在你的功能：

public string Get_Field_By_Id(string table_Name,string field_Name,string PK_val)
{
    using (var db = new mydbcontext())
        return Convert.ToString(db.GetColumnById(table_Name,field_Name,PK_val));
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!