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

The serve command requires to be run in an Angular project, but a project definition could not be found - Fixed

Azure - Failed to deploy web package to App Service. Internal Server Error (CODE: 500)- Fixed

Your global Angular CLI version (8.3.3) is greater than your local version (1.6.5). The local Angular CLI version is used.