月度归档： 2018 年 2 月

未定义键。请为该 EntityType 定义键 基于未定义任何键的类型 解决方法
提示这个错误，两个地方考虑
可能是模型没有加[Key],加上这个，如果还是报这个错误，检查下你的模型代码，是不是没有写{get;set;},遇到好几次这种..

一、方法1
首先拼接类（别管为什么，复制就行…）

using System;
using System.Collections.Generic;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using System.Threading.Tasks;

namespace FF
{
    //用户lambda表达式的拼接
    public static class PredicateBuilder
    {

        public static Expression<Func<T, bool>> True<T>() { return f => true; }
        public static Expression<Func<T, bool>> False<T>() { return f => false; }
        public static Expression<T> Compose<T>(this Expression<T> first, Expression<T> second, Func<Expression, Expression, Expression> merge)
        {
            // build parameter map (from parameters of second to parameters of first)  
            var map = first.Parameters.Select((f, i) => new { f, s = second.Parameters[i] }).ToDictionary(p => p.s, p => p.f);

            // replace parameters in the second lambda expression with parameters from the first  
            var secondBody = ParameterRebinder.ReplaceParameters(map, second.Body);

            // apply composition of lambda expression bodies to parameters from the first expression   
            return Expression.Lambda<T>(merge(first.Body, secondBody), first.Parameters);
        }

        public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
        {
            return first.Compose(second, Expression.And);
        }

        public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> first, Expression<Func<T, bool>> second)
        {
            return first.Compose(second, Expression.Or);
        }
    }
    public class ParameterRebinder : ExpressionVisitor
    {
        private readonly Dictionary<ParameterExpression, ParameterExpression> map;

        public ParameterRebinder(Dictionary<ParameterExpression, ParameterExpression> map)
        {
            this.map = map ?? new Dictionary<ParameterExpression, ParameterExpression>();
        }

        public static Expression ReplaceParameters(Dictionary<ParameterExpression, ParameterExpression> map, Expression exp)
        {
            return new ParameterRebinder(map).Visit(exp);
        }

        protected override Expression VisitParameter(ParameterExpression p)
        {
            ParameterExpression replacement;
            if (map.TryGetValue(p, out replacement))
            {
                p = replacement;
            }
            return base.VisitParameter(p);
        }
    }
}

引用 方法

var predicate = FF.PredicateBuilder.True();
//和操作
var predicate = predicate.And(a => a.DeviceID == deviceid);
//或操作
predicate = predicate.Or(a => a.DeviceID == deviceid);

//将predicate 放入条件
var list = db.dbSet.Where(predicate);
//另外记得引用命名空间 这里是 FF
using FF;

二、方法2
增加一个Expression扩展类

public static class ExpressionExt
{
    public static Expression<Func<T, bool>> And<T>(this Expression<Func<T, bool>> expr1, Expression<Func<T, bool>> expr2)
    {          
        return Expression.Lambda<Func<T, bool>>(Expression.AndAlso(expr1.Body, expr2.Body), expr1.Parameters);
    }
    public static Expression<Func<T, bool>> Or<T>(this Expression<Func<T, bool>> expr1,Expression<Func<T, bool>> expr2)
    {
        return Expression.Lambda<Func<T, bool>>(Expression.OrElse(expr1.Body, expr2.Body), expr1.Parameters);
    }
}

使用方法：

Expression<Func<Models.Content, bool>> exp= s => s.IsDel==false;
            exp = exp.And(s => s.IsHot == true);

Razor foreach获取索引方法

@{int i = 0;}
                @foreach (DataRow dr in ((DataTable)ViewData["set"]).Rows)
                {
                    i++;
                        <tr>
                            <td>@i</td>
                            <td>@dr["UserName"]</td>
                            <td>@dr["MPhone"]</td>
                        </tr>
                }

Razor与字符串组合

@foreach (var rd in item.User)
{
  <li>
       <input type="radio" value="@rd.UserName" id="rid@(rd.UserID)" name="radiogroup" />
       <label for="rid@(rd.UserID)">@rd.UserName</label>
  </li>
}

Razor 三元表达式

<div @Html.Raw(i==1?"class='active'":"")>@item.JDName</div>
//否则输出为 class=&39;active&39;