如何在EF Core 3.1中使用Join

var result = from table1 in dbContext.Table1
             join table2 in dbContext.Table2 on table1.Id equals table2.Table1Id
             select new
             {
                 // Select the desired columns from both tables
                 Column1 = table1.Column1,
                 Column2 = table2.Column2
             };

var result = dbContext.Table1
    .Join(dbContext.Table2,
        table1 => table1.Id,
        table2 => table2.Table1Id,
        (table1, table2) => new
        {
            // Select the desired columns from both tables
            Column1 = table1.Column1,
            Column2 = table2.Column2
        });