*C# Code:* var query = Session.QueryOver<RealtyFile>(() => realtyFileAlias); query = query.Fetch(sub => sub.Realty).Eager;
query = query.Inner.JoinAlias(() => realtyFileAlias.Realty, () => realtyAlias, realty => realty.Id == realtyFileAlias.RealtyId && !realty. IsDeleted); var retVal = query.Where(() => !realtyFileAlias.IsDeleted && realtyFileAlias .TypeId == (int)RealtyFileType.Image) .SelectList(builder => builder .Select(file => file.RealtyId)).List<int>(); *Exception:* NHibernate.StaleStateException: 'Batch update returned unexpected row count from update; actual row count: 0; expected: 1' *SQL Server Profiler Trace:* There are lots of UPDATE statements!!! Update statements is not related to realty or realtyfile tables. This is also interesting. İ don't know why? Is there any comment please? -- 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.
