nhibernate-projections
When to use Hibernate projections?
I am a little confused about Hibernate\'s projections and criteria. When to use projections and wh开发者_如何学运维en to use criteria?They\'re not mutually exclusive, you can use both at the same time[详细]
2023-04-06 04:21 分类:问答How to build string query with NHibernate?
I would like to reproduce this query with NHibernate using projection SELECT (\'reword#\' || reword) || reword_faq as foo FROM me_review_entries re[详细]
2023-03-18 20:10 分类:问答Help with conditional projection queries
I have a requirement wherein I need to display a list of employees and their roles. So if the role of the employee is Accounting, I want to display FirstName and LastName of that employee. Below is my[详细]
2023-03-12 17:54 分类:问答nHibernate QueryOver Projects - are Select and Where the same thing?
Using nHibernate QueryOver, if I want to enforce a projection for performance, are \"Select\" and \"Where\" the same thing? In other words, will ..[详细]
2023-03-11 04:48 分类:问答projection of type average(datediff) always returns 0.0
This is very puzzling; the generated SQL is perfectly good, and I get correct results when running it manually.[详细]
2023-03-10 18:48 分类:问答Concatenate fields using NHibernate projections
Using the accepted answer to this question I have been able to concatenate two fields using ICriteria and projections. I have ended up with[详细]
2023-03-08 06:56 分类:问答How to do this in nhibernate queryover
I need to do this in nhibernate QueryOver: select distinct sc.* from [Security].[Commands] sc inner join [Security].[SystemSubjects] ss on ss.Id = sc.Id[详细]
2023-02-12 17:45 分类:问答Can I use NHibernate Criteria to project an entity and its child collection onto a class?
I\'m using NH Criteria to retrieve an entity and project selective fields onto a custom class (a bit like projecting da开发者_StackOverflow社区ta onto a ViewModel for display on an MVC view).[详细]
2023-02-10 06:04 分类:问答Help with group by clause in projection queries
I want to group records of people coming in on any airport per day per hour. So basically I want a count of people coming in everyhour at any particular airport. Below is my code for it.[详细]
2023-02-08 20:21 分类:问答Help with NHibernate Criteria query groupby property
I have the below query, SearchTemplate Template = new SearchTemplate(); Template.Criteria = DetachedCriteria.For(typeof(table1));[详细]
2023-02-07 19:13 分类:问答