TProjections.Sql => Escape curly brackets

[Silber_Felix]

I've found:

Linq.Sql => Escape curly brackets strings

Is there anyway we could escape curly brackets when using Linq.Sql , without having to use the database's char or chr function? When I have a condition like Linq.Sql('entity_id = ''{xxx-any-38char-guid-xxx}'' '), it tries to find a column &/or property named as whatever I have between these brackets (generating an error, as this property doesn't exist).

but how could this be done for Projections?
We are using some Criteria-Fetches, executing subselects containing GUIDs.

How could I escape curly brackets within these subselects?

[wlandgraf (Wagner Landgraf)]

Do you have an example of the projections you are trying to use?

[Silber_Felix]

Manager.Find(TEntity)
  .Select(TProjections.ProjectionList
    .Add(Dic.Entity.Id)
    .Add(TProjections.Sql<string>('SELECT translation FROM ENTITY_LANG el WHERE el.PARENT_ENTITY_ID = {id} AND el.LANGUAGE_INDEX = ''{someguid}'' AND el.LANGUAGE = ''de-DE''')
    ).UniqueResult;

Well, I could just skip these curly brackets, because postgres would find this without curly brackets.

We only need this subselects because, FetchEager is not yet implemented for ManyValuedAssocs.
If FetchEager could fetch ManyValuedAssocs in a single statement, we could just iterate through our ManyValuedAssociation.

[wlandgraf (Wagner Landgraf)]

@Silber_Felix

Well, I could just skip these curly brackets, because postgres would find this without curly brackets.

For now you should do this, indeed. Parameters are not supported in projections.

@Silber_Felix

If FetchEager could fetch ManyValuedAssocs in a single statement, we could just iterate through our ManyValuedAssociation.

You can always do run a criteria over the detail class, not the parent class.