Hi,

I need to do this HQL:

i have 2 tables: Project(ProjectId, Name) and Users(userId, Name) and a Many to Many relation.
1 project have many users and 1 user have many projects.
this results in a other table: ProjectUser(id, ProjectId, userId)
this structure already is mounted in the Active Record and nHibernate.

i'm using Active Record with nHibernate and im trying to verify if a user is a project's member. I try with ExecuteScalar(@"Select COUNT(*) From ... Join ...); but this dont work...

I need Help please!

Can you be a bit more specific about your problem ? Classes, code for your hql query ... ?

You can try something like

"select count(*) from Project p inner join p.Users
where ? in elements(p.Users)"

and check if the result set is greater 0 (you may get mor than 1 result due to the join which results in a project for each user in that project). But for me that does not look like the best approach. Can you post more information ?

works fine!!!!

thanks!

it's the method:

public bool VerificaVinculoUsuario(Projeto projeto, Usuario usuario)
{
string sql = "select count(*) from Projeto p inner join p.UsuariosAssociados where ? in elements(p.UsuariosAssociados) and p = ?";
return ExecuteScalar<long>(sql, usuario, projeto) > 0;
}