EF Core 数据库视图查询

首先将视图作为一个数据表

实体类示例代码

using System;
using System.Collections.Generic;
using System.Text;

namespace Cari.secda.Entities
{
    /// <summary>
    /// 数据对接返回数据
    /// </summary>
    public class DataDockingView
    {
        /// <summary>
        /// 业务模块名称
        /// </summary>
        public string ModuleName { get; set; }
        /// <summary>
        /// 业务编码
        /// </summary>
        public string ModuleCode { get; set; }
        /// <summary>
        /// 审核通过数
        /// </summary>
        public int PassCount { get; set; }
        /// <summary>
        /// 审核不通过数
        /// </summary>
        public int NoPassCount { get; set; }
        /// <summary>
        /// 未审核数
        /// </summary>
        public int WaitAuditCount { get; set; }
        /// <summary>
        /// 集团下发数
        /// </summary>
        public int DownSendCount { get; set; }
        /// <summary>
        /// 页面跳转路径
        /// </summary>
        public string PathUrl { get; set; }
    }
}

在数据库上下文中OnModelCreating中将表数据映射为视图

示例代码

using Cari.IBP.Platform.Utility;
using Cari.IBP.Platform.Utility.Models;
using Cari.secda.Entities;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.ChangeTracking;
using Pomelo.EntityFrameworkCore.MySql.Infrastructure;
using Pomelo.EntityFrameworkCore.MySql.Storage;
using System;
using System.Collections.Generic;
using System.Reflection;
using System.Text;

namespace Cari.secda.Context
{

    public class ModuleNameDbContext : DbContext

    {
        private readonly ISession session;

        public ModuleNameDbContext(DbContextOptions<ModuleNameDbContext> dbContextOptions, ISession session) : base(dbContextOptions)
        {
            this.session = session;
        }

        public DbSet<DataDockingView> DataDockingView { get; set; }

        public void EnableFilter()
        {
            //this.Filter<Test>(x=>x.)
        }

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {

            modelBuilder.ApplyConfigurationsFromAssembly(Assembly.GetExecutingAssembly());

            //modelBuilder.Entity<BaseEntity>().HasQueryFilter(x => !x.Deleted);
            modelBuilder.Entity<DataDockingView>(entity => { entity.HasNoKey(); entity.ToView("DataDocking"); });//映射为视图数据查询 视图名称为DataDocking


            base.OnModelCreating(modelBuilder);
        }
    }
}