如何在Entity Framework6中连接两个实体以获得翻译后的文本

// 实体类
public class Article
{
    public int Id { get; set; }
    public string Title { get; set; }
    public int LanguageId { get; set; }
    public Language Language { get; set; }
}

public class Language
{
    public int Id { get; set; }
    public string Name { get; set; }
}

// 数据库上下文类
public class MyDbContext : DbContext
{
    public DbSet<Article> Articles { get; set; }
    public DbSet<Language> Languages { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        // 配置实体关系
        modelBuilder.Entity<Article>()
            .HasRequired(a => a.Language)
            .WithMany()
            .HasForeignKey(a => a.LanguageId);
    }
}

// 查询并获取翻译后的文本
using (var context = new MyDbContext())
{
    var translatedTexts = context.Articles
        .Join(context.Languages,
            article => article.LanguageId,
            language => language.Id,
            (article, language) => new { article.Title, language.Name })
        .ToList();

    foreach (var text in translatedTexts)
    {
        Console.WriteLine($"Title: {text.Title}, Language: {text.Name}");
    }
}