Fluent NHibernate “Could not resolve property”

So this error comes when your n-hibernate query is not proper sql query.

For example

your query is
var riAlbum = session.QueryOver<Album>()
                .Where(x => x.Name == albumName && x.Artist.Name == artist)
                .List().FirstOrDefault();
this query will convert into sql as below
select
    Album.*
from
    Album
where
    Album.Name = 'SomeAlbumName' and
    Album.Artist.Name = 'SomeArtistName'
so that is wrong as last line 'Album.Artist.Name' is not proper sql. so u have to apply join in your n-hibernate query.

var riAlbum = 
    session.QueryOver<Album>()
               .Where(a => a.Name == albumName)
           .JoinQueryOver(a => a.Artist)
               .Where(ar => ar.Name == artistName)
           .List()
           .FirstOrDefault();



Comments

Popular posts from this blog

Swagger for Azure functions: Undocumented TypeError: Failed to execute 'fetch' on 'Window': Request with GET/HEAD method cannot have body. Fixed.

Fixed: The required column was not present in the results of a 'FromSql' operation in asp.net core EF core

Severity Code Description Project File Line Suppression State Error Unable to resolve dependencies. 'Xamarin.Android.Support.Design 24.2.1' is not compatible with 'Xamarin.Forms 2.3.3.180 constraint: Xamarin.Android.Support.Design (= 23.3.0)'. 0