NHibernate - using custom sql query for a column

Question

Is there any way to use custom sql with NHibernate? I want to use a complex sql for a specific column.

Example:

select id, viewsCount, commentsCount, 
  0.2 * viewsCount / (select top 1 viewsCount from articles where isActive = 1 order by viewsCount DESC) as priorityViews, 
  0.8 * commentsCount / (select top 1 commentsCount from articles where isActive = 1 order by commentsCount DESC) as priorityComments, 
  round(0.2 * viewsCount / (select top 1 viewsCount from articles where isActive = 1 order by viewsCount DESC) +  
  0.8 * commentsCount / (select top 1 commentsCount from articles where isActive = 1 order by commentsCount DESC), 1) as priority
from articles

Mauricio Scheffer · Accepted Answer · 2010-05-31 22:38:18Z

2

You can do this in your mapping with the formula attribute, or in your query with Projections.SqlProjection()

answered May 31, 2010 at 22:38

Mauricio Scheffer

100k24 gold badges197 silver badges280 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

NHibernate - using custom sql query for a column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related