IT小易 2019-08-27 13:19 采纳率: 33.3%
浏览 508
已采纳

asp.net core+EF架构查询数据库时报错

asp.net core+EF架构查询数据库时报错
Entities代码

[Table("Dictionary")]
    [Serializable]
    public partial class Dictionary
    {
        /// <summary>
        /// 数据字典ID
        /// </summary>
        public Guid Id { get; set; }

        /// <summary>
        /// 字典名称
        /// </summary>
        public string Name { get; set; }

        /// <summary>
        /// 字典编码
        /// </summary>
        public string Code { get; set; }

        /// <summary>
        /// 数据类型
        /// </summary>
        public int? Type { get; set; }

        /// <summary>
        /// 父级ID
        /// </summary>
        public Guid Pid { get; set; }

        /// <summary>
        /// 排序权重
        /// </summary>
        public int? Sort { get; set; }

        /// <summary>
        /// 是否启用
        /// </summary>
        public bool Enabled { get; set; }

        /// <summary>
        /// 是否删除
        /// </summary>
        public bool Deleted { get; set; }

        /// <summary>
        /// 创建用户ID
        /// </summary>
        public Guid CreateId { get; set; }

        /// <summary>
        /// 创建日期
        /// </summary>
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 更新用户ID
        /// </summary>
        public Guid UpdateId { get; set; }

        /// <summary>
        ///更新日期 
        /// </summary>
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        public string Remark { get; set; }
    }
上下文代码

public class EntityDbContext : DbContext
    {
        public EntityDbContext(DbContextOptions options) : base(options)
        {

        }
        public DbSet<Category> Categories { get; set; }
        public DbSet<SysUser> SysUsers { get; set; }
        public DbSet<SysUserToken> SysUserTokenes { get; set; }
        public DbSet<SysUserLoginLog> SysUserLoginLogs { get; set; }
        public DbSet<SysUserRole> SysUserRoles { get; set; }
        public DbSet<SysPermission> SysPermissions { get; set; }
        public DbSet<Dictionary> Dictionaries { get; set; }
    }

        调用代码
        private IRepository<Entities.Dictionary> _dictionaryRepository;
        private IHttpContextAccessor _accessor;

        public DictionaryService(IRepository<Entities.Dictionary> dictionaryRepository, IHttpContextAccessor accessor)
        {
            this._dictionaryRepository = dictionaryRepository;
            this._accessor = accessor;
        }
        /// <summary>
        /// 获取所有数据字典并缓存
        /// </summary>
        /// <returns></returns>
        public List<Entities.Dictionary> getAll()
        {
            var result = _dictionaryRepository.Table.Where(o => !o.Deleted);
            var ex = result.Expression;
            //result = result.Where(o => o.Code == "KGJ-2019-T-001" || o.Code == "KGJ-2019-T-002");
            //return result.OrderBy(o => o.Type).ThenBy(o => o.CreateTime).ToList();
            throw new NotImplementedException(ex.ToString());
        }

报错问题:图片说明

  • 写回答

2条回答 默认 最新

  • threenewbee 2019-08-27 13:35
    关注

    throw new NotImplementedException(ex.ToString());
    这个去掉。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥60 版本过低apk如何修改可以兼容新的安卓系统
  • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
  • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
  • ¥50 有数据,怎么用matlab求全要素生产率
  • ¥15 TI的insta-spin例程
  • ¥15 完成下列问题完成下列问题
  • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?