mysql - 使用 NHibernate QueryOver<> 获取表中的所有字段

Question

我正在使用 Nhibernate 的 QueryOver<>从现有数据库中读取。我知道表中有记录，但它在生成 View 时只显示字段名称。

public ActionResult Index()
    {
        myConfiguration = new Configuration();
        myConfiguration.Configure();
        mySessionFactory = myConfiguration.BuildSessionFactory();

        IList<DriverHeader> drivers;
        using (ISession session = mySessionFactory.OpenSession())
        {
            drivers = session.QueryOver<DriverHeader>().List();
        }

        return View(drivers);
    }

Answer 1

尝试添加选择(用于投影)，为您想要的每个字段添加一个:

public ActionResult Index()
    {
    myConfiguration = new Configuration();
    myConfiguration.Configure();
    mySessionFactory = myConfiguration.BuildSessionFactory();

    IList<DriverHeader> drivers;
    using (ISession session = mySessionFactory.OpenSession())
    {
        drivers = session.QueryOver<DriverHeader>()      
                         .SelectList(list => list
                         .Select(x => x.field).WithAlias(() => dtoDriverHeader.field)
                  .List();
    }

    return View(drivers);
}