I am stumped. I've been over this too many times and it's time for some
extra eyes on my problem.
I'm using FluentNHibernate for my mappings.
The problem that I am having is that when I am querying my League table for
a League that has a specified ID, the generated SQL tries to match the ID up
with a Sub Classes ID instead of the parent class.
For instance.
League
BaseballLeague : League
FootballLeague : League
I get nothing back if I pass in an ID of a FootballLeague.
(all of the mapping for the main class gets done in the
NamedDomainObjectMap)
public class LeagueMap : NamedDomainObjectMap<League>
{
/// <summary>
/// Initializes a new instance of the LeagueMap class.
/// </summary>
public LeagueMap()
: base()
{
var ncaaMap = JoinedSubClass<NcaaLeague>("NcaaLeagueId", sub =>
sub.Map(x => x.Id));
var mlbMap = JoinedSubClass<MlbLeague>("MlbLeagueId", sub =>
sub.Map(x => x.Id));
}
}
var criteria = Session.CreateCriteria(typeof(League))
.Add(Expression.Eq("Id", id ))
.UniqueResult<League>();
the generated where statement is:
WHERE *this_1_.Id *= 'f5e2e4ef-a682-439f-b0f1-22906b71953d' /* @p0 */
it works perfectly if I change it to WHERE* this_.Id* =
'f5e2e4ef-a682-439f-b0f1-22906b71953d' /* @p0 */
So you see, it's going off the first subclass to be mapped. What the hell
is going wrong?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
