• LINQ to Entities does not recognize the method 'Int64 ToUnixTime(System.DateTime)' method,and this method cannot be translated into a store expression


    关于在LINQ表达式中出现错误,就是方法不能将时间转成表达式,经过不断的思考,终于明白了转码解决。本人就是想把后台的时间对象转成时间戳然后传给前台调用。

    这样就出错:

     var comments = CommentSrv.GetListByCondition(t => t.ProductId == id //商品评论

                                     && t.Type ==Type

                                     && t.Content != null

                                    && t.Content != " ").OrderByDescending(t => t.CreateDate);
     var product = new {//展示商品的评论内容(包含时间,商品名,评论)
                        data.ID,
                        data.Name,
                        Commnents = comments,
                        CreateDate = t.CreateDate.ToUnixTime()//时间转换
                        };

    失败提示:
    LINQ to Entities does not recognize the method 'Int64 ToUnixTime(System.DateTime)' method, and this method cannot be
    translated into a store expression.

    修改后:

    var comments = CommentSrv.GetListByCondition(t => t.ProductId == id //商品评论

                                     && t.Type ==Type

                                     && t.Content != null

                                    && t.Content != " ").OrderByDescending(t => t.CreateDate)).ToList();//只要修改这里就可以
     var product = new {//展示商品的评论内容(包含时间,商品名,评论)
                        data.ID,
                        data.Name,
                        Commnents = comments,
                        CreateDate = t.CreateDate.ToUnixTime()//时间转换毫秒
                        };

    时间戳转换结果:

    "CreateDate":1336755430000

  • 相关阅读:
    LoadRunner ---手动关联与预关联
    Error -27780: [GENERAL_MSG_CAT_SSL_ERROR]connect to host "124.202.213.70" failed: [10054] Connection reset by peer [MsgId: MERR-27780]
    LR录制https协议报证书错误,导航已阻止
    python sort和sorted的区别以及使用方法
    python 操作exls学习之路1-openpyxl库学习
    python json学习之路2-认识python种的json模块
    python json学习之路1-认识json格式数据
    磁盘性能测试学习之路2-测试磁盘性能工具的选择
    磁盘性能测试学习之路1-认识磁盘的各项参数
    飞机进度条
  • 原文地址:https://www.cnblogs.com/janekimyan/p/3496803.html
Copyright © 2020-2023  润新知