First of all let me apologize for the length of this article, it is mainly code, so I hope you all bear with me!
I have a scenario dealing with a legacy database, I need to write an IUserType
Tag: Queryover
SELECT – NHIBERNATE Queryover Case WHEN Calculation Value
I have been trying to execute the following T-SQL in NHibernate QueryOver, but without success:
SELECT Id, SUM (CASE MyValue WHEN 1 THEN Volume ELSE Volume * -1 END)
FROM MyTable
GROUP BY Id
.NET – Queryover’s query generator or extension point is the same as Linq?
I’m trying to use the calculated properties used by Query< T>() inside QueryOver< T>(). When using LINQ queries, I can use the custom Default LinqToHqlGeneratorsRegistry to register the custom gene