Bom dia pessoal.
Tenho uma consulta feita com Criteria e o select tá chegando todo bagunçado no banco.
A sql fica assim:
SELECT this_.ID as ID10_1_, this_.GroupID as GroupID10_1_, this_.UserLogin as UserLogin10_1_, this_.Name as Name10_1_,
this_.UserPassword as UserPass5_10_1_, this_.Image as Image10_1_, tabela2_.ID as ID2_0_, tabela2_.Name as Name2_0_
FROM minhaTabela this_ left outer join minhaOutraTabela tabela_ on this_.GroupID=tabela_.ID WHERE this_.UserLogin = ? ]
Positional parameters: #0>meuLogin
<textarea class="java" style="display: none;" cols="60" rows="10" name="code">SELECT this_.ID as ID10_1_, this_.GroupID as GroupID10_1_, this_.UserLogin as UserLogin10_1_, this_.Name as Name10_1_, this_.UserPassword as UserPass5_10_1_, this_.Image
as Image10_1_, tabela2_.ID as ID2_0_, tabela2_.Name as Name2_0_ FROM minhaTabela this_ left outer join minhaOutraTabela tabela_ on this_.GroupID=tabela_.ID WHERE this_.UserLogin = ? ] Positional parameters: #0>meuLogin </textarea>
Alguém tem alguma idéia?
O banco é o sqlserver2008 e o dialeto é:
NHibernate.Dialect.MsSql2005Dialect