CSharp: donet 7 create database view mapping with EF core 7.02

 

sql: 

?

1 2 3 4 5

create view ViewEmployeeMasters as select a.*,b.Name as 'DepartmentName',b.Code as 'DepartmentCode' from EmployeeMasters as a,DepartmentMaster as b where a.DepartmentId=b.DepartmentId go

　　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84

/// <summary>     /// 视图     /// Create A Database View Using The Entity Framework (EF) Code First Approach     /// </summary>     public class ViewEmployeeMasters     {           public int EmployeeId { get; set; }           /// <summary>         ///         /// </summary>           public string Code { get; set; }         /// <summary>         ///         /// </summary>           public string Name { get; set; }           /// <summary>         ///         /// </summary>           public int DepartmentId { get; set; }           /// <summary>         ///         /// </summary>         public string DepartmentCode { get; set; }           /// <summary>         ///         /// </summary>         public string DepartmentName { get; set; }         /// <summary>           }         /// <summary>         /// 视图         /// </summary>         public DbSet<ViewEmployeeMasters> ViewEmployeeMasters { get; set; }         /// <summary>         ///         /// </summary>         /// <param name="optionsBuilder"></param>           protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)         {               //读取配置文件             var config = new ConfigurationBuilder()                 .SetBasePath(Directory.GetCurrentDirectory()) //Environment.CurrentDirectory                 .AddJsonFile("appsettings.json")                 .AddInMemoryCollection()                 .Build();             var connStr = config["ConnectionStrings:GeovinDuDbContext"];                 // optionsBuilder.UseSqlServer("Server=DESKTOP-NQK85G5\\GEOVIN2008;Database=geovindu;User Id=sa;Password=geovindu;");             optionsBuilder.UseSqlServer(connStr);         }         /// <summary>         /// https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/whatsnew         /// 存储过程映射         /// Stored procedure mapping         /// </summary>         /// <param name="modelBuilder"></param>         protected override void OnModelCreating(ModelBuilder modelBuilder)         {               modelBuilder.Entity<DuProduct>();             modelBuilder.Entity<DuCustomer>();             modelBuilder.Entity<People>();                 modelBuilder.Entity<ViewEmployeeMasters>().ToView("ViewEmployeeMasters")                 .HasNoKey();   }

　　

调用：

?

1 2 3 4 5 6 7 8 9 10

DuDbContext context = new DuDbContext();     var viewEmployeeMasters = context.ViewEmployeeMasters     .Where(po => po.EmployeeId < 10)     .ToList(); foreach(ViewEmployeeMasters em in viewEmployeeMasters) {     Console.WriteLine(em.Name+"  视图查询"); }

　　

输出：

?

1 2 3 4

Security Warning: The negotiated TLS 1.0 is an insecure protocol and is supported for backward compatibility only. The recommended protocol version is TLS 1.2 and later. 涂聚文  视图查询 ok edit,ok