I\'m trying to restrict a left outer join with a simple restriction but it fails with an sql exception.
I am developing a small web application, using nhibnerate as my DAL. I have to classes that I wish to select from, using a simple ICriteria.
First of all, I\'m sure there must be a simple solution to this but I just can\'t find it. (Yes, I have googled it)
Here\'s my (simplified) model: Ticket -> Customer Callback (s) I have my Ticket mapped so that when it\'s loaded, the Callbacks are as well.
I have a process which generates a result set for me and stores it in a temporary table.I have the name of the temporary table.I am trying to find a way, using NHibernate, to create a DetachedCriteria
I have an object graph that looks like this: class A () { int id; IEnumerable<B> bees; } class B() { int id;
Using the accepted answer to this question I have been able to concatenate two fields using ICriteria and projections. I have ended up with
In a forum, I want to list the most recent posts from each topic. In SQL I can do a subquery with group by Topic taking Max(Post.Date) and then make an inner join with the Posts table to get the lates
I have to simple entities public class EntityA { public virtual int ID { get;set;} public virtual string Name { get;set;}
I\'m trying to generate SQL along the lines of: SELECT t.*, SELECT (...) FROM Title t [trimmed] using QueryOver