如何在.net核心中访问数据库上下文表单视图

using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    public DbSet<Employee> Employees { get; set; }
    public DbSet<EmployeeView> EmployeeViews { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        // 配置数据库连接字符串
        optionsBuilder.UseSqlServer("YourConnectionString");
    }
}

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
}

public class EmployeeView
{
    public int Id { get; set; }
    public string Name { get; set; }
    public string Department { get; set; }
    public int TotalEmployees { get; set; }
}

using (var context = new MyDbContext())
{
    var employees = context.Employees.ToList();
    // 对查询结果进行处理
}

using (var context = new MyDbContext())
{
    var employeeViews = context.EmployeeViews.ToList();
    // 对查询结果进行处理
}