NHibernate.QueryException：无法解析属性 [英] NHibernate.QueryException: could not resolve property

问题描述

我正在使用FluentNHibernate和Linq To Nhibernate，这些实体（仅相关部分）：

I'm using FluentNHibernate and Linq To Nhibernate, with these entities (only the relevant parts):

public class Player : BaseEntity<Player>
{
    private readonly IList<PlayerInTeam> allTeams = new List<PlayerInTeam>();

    public IEnumerable<Team> Teams
    {
        get
        {
            return from playerInTeam in allTeams
                   where playerInTeam.Roster.Match == null
                   select playerInTeam.Roster.Team;
        }
    }
}

public class PlayerInTeam : BaseEntity<PlayerInTeam>
{
    public int PlayerNumber { get; set; }
    public Player Player { get; set; }
    public Position Position { get; set; }
    public Roster Roster { get; set; }
}

public class Roster : BaseEntity<Roster>
{
    private readonly IList<PlayerInTeam> players = new List<PlayerInTeam>();

    public Team Team { get; set; }
    public IEnumerable<PlayerInTeam> Players { get { return players; } }
}

public class Team : BaseEntity<Team>
{
    private readonly IList<Roster> allRosters = new List<Roster>();

    public Team(string name, Sex sex)
    {
        allRosters.Add(new Roster(this));
    }

    public Roster DefaultRoster
    {
        get { return allRosters.Where(r => r.Match == null).First(); } 
    }
}

和匹配的映射：

public class PlayerMap : ClassMap<Player>
{
    public PlayerMap()
    {
        HasMany<PlayerInTeam>(Reveal.Member<Player>("allTeams"))
            .Inverse()
            .Cascade.AllDeleteOrphan()
            .Access.CamelCaseField();
    }
}

public class PlayerInTeamMap : ClassMap<PlayerInTeam>
{
    public PlayerInTeamMap()
    {
        References(pit => pit.Player)
            .Not.Nullable();

        References(pit => pit.Roster)
            .Not.Nullable();
    }
}

public class RosterMap : ClassMap<Roster>
{
    public RosterMap()
    {
        References(tr => tr.Team)
            .Not.Nullable();

        HasMany<PlayerInTeam>(Reveal.Member<Roster>("players"))
            .Inverse()
            .Cascade.AllDeleteOrphan()
            .Access.CamelCaseField();
    }
}

public class TeamMap : ClassMap<Team>
{
    public TeamMap()
    {
        HasMany<Roster>(Reveal.Member<Team>("allRosters"))
            .Inverse()
            .Cascade.AllDeleteOrphan()
            .Access.CamelCaseField();
    }
}

我有这个存储库方法：

public IEnumerable<Player> PlayersNotInTeam(Team team)
{
    return from player in Session.Linq<Player>()
            where !player.Teams.Contains(team)
            select player;
}

哪个给我这个例外：NHibernate.QueryException：无法解析属性：团队：Emidee.CommonEntities.Player [.Where（NHibernate.Linq.NhQueryable`1 [Emidee.CommonEntities.Player]，Quote（（player，）=>（Not（.Contains（player.Teams，p1， ））））]]

Which gives me this exception: NHibernate.QueryException: could not resolve property: Teams of: Emidee.CommonEntities.Player [.Where(NHibernate.Linq.NhQueryable`1[Emidee.CommonEntities.Player], Quote((player, ) => (Not(.Contains(player.Teams, p1, )))), )]

我看过Fluent NHibernate生成的hbm文件，关于Player，这里是我得到的： / p>

I've looked inside the hbm file, generated by Fluent NHibernate, concerning Player, and here is what I get:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-access="property" auto-import="true" default-cascade="none" default-lazy="true">
  <class xmlns="urn:nhibernate-mapping-2.2" mutable="true" name="Emidee.CommonEntities.Player, Emidee.CommonEntities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=65c7ad487c784bec" table="Players">
    <id name="Id" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
      <column name="Id" />
      <generator class="increment" />
    </id>
    <bag access="field.camelcase" cascade="all-delete-orphan" inverse="true" name="allTeams" mutable="true">
      <key>
        <column name="Player_id" not-null="true" />
      </key>
      <one-to-many class="Emidee.CommonEntities.PlayerInTeam, Emidee.CommonEntities, Version=1.0.0.0, Culture=neutral, PublicKeyToken=65c7ad487c784bec" />
    </bag>
  </class>
</hibernate-mapping>

的确，我没有在该文件中的Player的Teams属性。

Indeed, I don't have a Teams property for Player in that file.

但是我的映射不应该照顾这个？
你觉得问题在哪里？

But shouldn't my mapping take care of this? Where do you think the problem is?

提前感谢

Mike

推荐答案

从技术上来说，不可能在C-sharp中查看方法体。所以FluentNhibernate也不行。您必须应用不同的策略来建模实体和/或自己生成映射。

Technically, it's not possible to look inside a method body in C-sharp. So FluentNhibernate can not do that as well. You have to apply a different strategy to model your entities and/or generate the mapping yourself.

这篇关于NHibernate.QueryException：无法解析属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！