My colegue has found what was the problem.

There was next code in our test project:

   class SessionInterseptor:
        EmptyInterceptor
        , .......
    {
        public override SqlString OnPrepareStatement(SqlString sql)
        {
            string s = sql.ToString();
            s = s.Replace("WHERE ", "WHERE 1=1 AND ");

            return SqlString.Parse(s);
        }
...................

If remove this code or replace to

        public override SqlString OnPrepareStatement(SqlString sql)
        {
            return sql.Replace("WHERE ", "WHERE 1=1 AND ");
        }

all works correct.

This code was created and forgotten. It was investigation where it is
possible to modify sql created by NH for applying filtering using "by
object" access list.

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to