This is intended because of the difference of null semantic in SQL and .NET
In SQL null does not equal nor does not not-equal to anything (any comparison expression involving null gives false). So the expression null <> "" is false. In .NET null behaves as a normal object. Best Regards, Alexander On Mon, Mar 19, 2018 at 2:17 AM, Gof <[email protected]> wrote: > in 5.1.0 working. > > new problem > > .Where(x => x.InternalId != "") > > => > > internal_id <> ''''' or internal_id is null > > > why is that? > > > > четверг, 15 марта 2018 г., 18:47:57 UTC+3 пользователь Gof написал: > >> 1 .Query<XmlFid>() >> .Cacheable() >> .CacheMode(CacheMode.Normal) >> .Fetch(x => x.User) >> .SingleOrDefault(x => x.Id == 1); >> >> error: Parameter 'inputInfo' has type >> 'Remotion.Linq.Clauses.StreamedData.StreamedSingleValueInfo' >> when type 'Remotion.Linq.Clauses.StreamedData.StreamedSequenceInfo' was >> expected. >> similar - https://nhibernate.jira.com/browse/NH-3186 >> >> 2 .Query<XmlFid>() >> .Cacheable() >> .CacheMode(CacheMode.Normal) >> .Fetch(x => x.User) >> .SingleOrDefault(); >> >> ideas how to fix?? >> >> NHibernate Version 5.0.3 >> >> -- > 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. > -- 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.
