public IList <string> FilmTitleWhereWasPartecipateSpecificActor(int ActorId)
{
var parameters = CreateDbParameters();
string parameterName = string.Empty;
string parameterName4Sql = string.Empty;
parameterName = "idActor";
parameterName4Sql = DaoHelper.GetParamNameForProvider(parameterName);
parameters.AddWithValue(parameterName4Sql, ActorId);
Film film = null;
//Actor actor = null;
//Cast cast = null;
string selectStr = @"SELECT DISTINCT FILMTITLE FROM {0} INNER JOIN CAST ON FILMS.ID = FILMID INNER JOIN ACTORS ON ACTORID = ACTORS.IDACTOR WHERE ACTORS.IDACTOR = {1}".FormatWith(film.GetTableNameForEntity(), parameters[0].Value);
var builder =
NewSqlQueryBuilder()
.CustomSql(selectStr);
//.RegisterTableAlias(aliasFilm, film.GetTableNameForEntity())
//.RegisterTableAlias(aliasActor, actor.GetTableNameForEntity())
//.RegisterTableAlias(aliasCast, cast.GetTableNameForEntity())
//.Select()
//.Distinct()
//.AddFieldsToSelect<Film>(aliasFilm, x => x.FilmTitle)
//.From(aliasFilm)
//.InnerJoin(new TableDef {Alias = aliasCast, Schema = Schema, TableName = cast.GetTableNameForEntity() })
//.On()
//.JoinCondition(aliasFilm, film.GetFieldName( f => f.Id), WhereOperator.EqualTo, aliasCast, cast.GetFieldName(c => c.FilmId))
//.InnerJoin(new TableDef {Alias = aliasActor, Schema = Schema, TableName = actor.GetTableNameForEntity() })
//.On()
//.JoinCondition(aliasCast, cast.GetFieldName(c => c.ActorId), WhereOperator.EqualTo ,aliasActor, actor.GetFieldName(a => a.Id))
//.Where()
//.Condition<Actor>(aliasActor, a => a.Id, WhereOperator.EqualTo, idActor);
return(QueryForListOfString(builder));
}