ASP .NET中连接表的代码优先方法

using System;
using System.Linq;

namespace MyApplication
{
    public class Program
    {
        public static void Main(string[] args)
        {
            // 创建一个数据库上下文对象
            using (var dbContext = new MyDbContext())
            {
                // 使用LINQ进行表连接查询
                var query = from customer in dbContext.Customers
                            join order in dbContext.Orders on customer.Id equals order.CustomerId
                            select new
                            {
                                CustomerName = customer.Name,
                                OrderId = order.Id,
                                OrderDate = order.Date
                            };

                // 执行查询并输出结果
                foreach (var result in query)
                {
                    Console.WriteLine($"Customer: {result.CustomerName}, Order: {result.OrderId}, Date: {result.OrderDate}");
                }
            }
        }
    }

    // 定义数据库上下文类
    public class MyDbContext : DbContext
    {
        public DbSet<Customer> Customers { get; set; }
        public DbSet<Order> Orders { get; set; }

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

    // 定义实体类
    public class Customer
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public class Order
    {
        public int Id { get; set; }
        public int CustomerId { get; set; }
        public DateTime Date { get; set; }
    }
}