Linq 到 NHibernate +转变+期货

发布于 2024-12-14 11:50:08 字数 671 浏览 4 评论 0原文

我知道您可以通过调用 .ToFuture<>() 扩展方法来执行 Linq to NHibernate 查询。不过，我没有加载映射实体，而是直接将数据加载到 DTO 中。所以你会得到这样的信息：

var results = (from e in session.Query<Entity>()
               where e.Reference.Id == someId
               orderby e.Name
               select new Dto
               {
                   Id = e.Id,
                   Name = e.Name,
                   // ...
               }).ToFuture<Dto>();

这并不像我想要的那样工作（我敢说预期）。我现在收到错误：值“System.Object[]”不是“Entity”类型，不能在此通用集合中使用。如果我删除 .ToFuture() code> 它确实有效，但查询不是批处理的。

我知道您可以使用 QueryOver API 来完成此操作，我只是更喜欢 Linq to NH，因为它的代码非常干净。

原文

I know you can execute a Linq to NHibernate query as a future by calling the .ToFuture<>() extension method. However I'm not loading mapped entities but directly loading the data into DTO's. So you get something like:

var results = (from e in session.Query<Entity>()
               where e.Reference.Id == someId
               orderby e.Name
               select new Dto
               {
                   Id = e.Id,
                   Name = e.Name,
                   // ...
               }).ToFuture<Dto>();

This doesn't work as I want it (I dare to say expected). I now get an error: The value "System.Object[]" is not of type "Entity" and cannot be used in this generic collection. If I remove .ToFuture() it does work, but the query is not batched.

I know you can do this with the QueryOver API, I just like Linq to NH better because it's so much cleaner code.

分享到QQ

分享到微博