如何使用linq和entity框架连接表

using System.Linq;
using System.Data.Entity;

public class MyDbContext : DbContext
{
    public DbSet<Table1> Table1 { get; set; }
    public DbSet<Table2> Table2 { get; set; }
    // 其他实体类...

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        // 配置实体类之间的关系...
    }
}

public class Table1
{
    public int Id { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

public class Table2
{
    public int Id { get; set; }
    public string Description { get; set; }
    // 其他属性...
}

using (var context = new MyDbContext())
{
    var query = from t1 in context.Table1
                join t2 in context.Table2 on t1.Id equals t2.Id
                select new { t1.Name, t2.Description };

    foreach (var result in query)
    {
        Console.WriteLine($"Name: {result.Name}, Description: {result.Description}");
    }
}