In version 1.04, I used to be able to add a sql expression to criteria object like:

criteria.Add(Expression.SQL("this.status='X'))

In version 1.2, such code throws a SQL Exception: The multi-part identifier "this.status" could not be bound.

Am I missing something?

You should be using {alias} instead of this.

Is there any other way besides {alias}. This messes up all the SQL strings formatted with string.format (because of the curly brackets)

You can use {alias} within a string.Format by doubling-up the braces, like this: "{{alias}}" String.Format will ignore double braces, kind of like an escape sequence.

did you say "we can use '{alias}' in our query"? please explain me more.

for example can i write a query like below?

SELECT {alias}.Name FROM ContactEntity AS ContactEntity

I confused! if yes, please explain more.

thanks in advance