How to perform a HQL query in C#?

Question

I need to create an HQL query within a method in C#. The structure goes like this: I have the method:

IList<int>GetListYear(Guid educationalInstitutionId, Guid academicLevelId, Guid? locationId, Guid? programOfferedId)
{
    //Implementar a consulta HQL
} 

And I have my HQL appointment:

"select distinct ConclusionYear
    from AlumniProgramOffered
    inner join AlumniSignup
    inner join ProgramOffered
    inner join Program
    where AlumniSignup.EducationalInstitution.Identity = educationalInstitutionId
and Program.AcademicLevel.Identity = academicLevelId
and ProgramOffered.Location.Identity = locationId or locationId is null
and ProgramOffered.Identity = programOfferedId or programOfferedId is null"

How can I assemble this structure to join the HQL query with the parameters I received from my method?

Answer 1

Guy would look something like this:

IList<int> GetListYear(Guid educationalInstitutionId, Guid academicLevelId, Guid? locationId, Guid? programOfferedId)
{
    StringBuilder hql = new StringBuilder();

    hql.Append(" select distinct ConclusionYear ");
    hql.Append(" from AlumniProgramOffered ");
    hql.Append(" inner join AlumniSignup ");
    hql.Append(" inner join ProgramOffered ");
    hql.Append(" inner join Program ");
    hql.Append(" where AlumniSignup.EducationalInstitution.Identity = :educationalInstitutionId ");
    hql.Append(" and Program.AcademicLevel.Identity = :academicLevelId ");
    hql.Append(" and ProgramOffered.Location.Identity = :locationId or locationId is null ");
    hql.Append(" and ProgramOffered.Identity = :programOfferedId or programOfferedId is null" ");

    Query query = Session.CreateHqlQuery(hql.ToString());
    query.SetParameter("educationalInstitutionId", educationalInstitutionId);
    query.SetParameter("academicLevelId", academicLevelId);
    query.SetParameter("locationId", locationId);
    query.SetParameter("programOfferedId", programOfferedId);

    return query.ToList<int>();
}