I am getting the following error:
Code:
NHibernate.QueryException : , expected in SELECT [select
p.Id, c.Name CompanyName, p.EndDate, p.TypeString Type,
p.FrequencyString Frequency from UR.App.Core.PayrollBatch p
left outer join p.Client c where c.Id = 614216 ]
This seems to me like a very straightforward query. I don't see where I am missing a comma. If I remove all the aliases, it works. I have tried several things: using the "as" keyword for aliases; aliasing all the columns; aliasing only one column at a time. It seems that if I have just one alias on any column in the select clause I get this error.
Unfortunately I cannot just remove the aliases. I am using a results transformer to transform this in a Dto list, which only works if projections are aliased.