Den mån 1 okt. 2018 kl 16:24 skrev Yılmaz Demir <[email protected]>:

> *Exception Line:*
>
> var retVal = query.Where(() => !realtyFileAlias.IsDeleted &&
> realtyFileAlias.TypeId == (int)RealtyFileType.Image)
> .SelectList(builder => builder .Select(file => file.RealtyId)).List<int>
> ();
>
>
>
>
>
> update for other tables that are not related in these tables mapping.
> Tables: Package and Account
>
> There are update processes for these tables before the query below.
>

Are you saying that you have, in the same session and transaction, loaded
objects from Package and Account and made changes to these objects? If so,
please explain why you find it surprising that NHibernate may decided to
issue these UPDATE statements to the database?

As for the exception... well, I expect the problem is with the update code
that you haven't shown, and not with the query that you do show.

Explore the exception AND ALL inner exceptions to see if the message or
stacktrace may give a clue.

Also consider activating DEBUG-logs for NHibernate.SQL - this should show
which exact SQL-statement didn't go as NHibernate expected.

/Oskar

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.

Reply via email to