如何使用NHibernate / Fluent NHibernate将2个数据库表中的记录包含到单个视图中？

// 实体类
public class Table1
{
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }
}

public class Table2
{
    public virtual int Id { get; set; }
    public virtual string Description { get; set; }
}

// 映射配置
public class Table1Map : ClassMap<Table1>
{
    public Table1Map()
    {
        Table("Table1");
        Id(x => x.Id);
        Map(x => x.Name);
    }
}

public class Table2Map : ClassMap<Table2>
{
    public Table2Map()
    {
        Table("Table2");
        Id(x => x.Id);
        Map(x => x.Description);
    }
}

// 查询和映射到视图模型
public class MyViewModel
{
    public string Name { get; set; }
    public string Description { get; set; }
}

public class MyRepository
{
    private readonly ISessionFactory _sessionFactory;

    public MyRepository(ISessionFactory sessionFactory)
    {
        _sessionFactory = sessionFactory;
    }

    public MyViewModel GetCombinedData()
    {
        using (var session = _sessionFactory.OpenSession())
        {
            var query = session.QueryOver<Table1>()
                .JoinQueryOver<Table2>(x => x.Table2)
                .SelectList(list => list
                    .Select(x => x.Name)
                    .Select(x => x.Table2.Description))
                .TransformUsing(Transformers.AliasToBean<MyViewModel>())
                .SingleOrDefault<MyViewModel>();

            return query;
        }
    }
}

// 使用示例
var sessionFactory = // 创建和配置SessionFactory
var repository = new MyRepository(sessionFactory);
var viewModel = repository.GetCombinedData();