Hi,
I have
class ProductGroup
{
public string Code{ get; set;}
}
class Product
{
public string Code { get; set; }
public ProductGroup Group { get; set; }
}
I map Product using (not all products belong to product group)
class ProductMapping : ClassMap<Product>
{
void ProductMapping()
{
References(x => x.Group).Nullable.NotFound.Ignore;
}
}
Now I'm give a code that could be for either the product or the
product group. The product and product group codes are mutually
exclusive so I query as follows,
session.Query<Product>().Where(x => x.Code = "123" || x.Group.Code =
"123");
This results in an inner join (or the non-ansi 92 equivalient). As
such a product that doesn't belong to a product group but has code
"123" will not be returned in the query.
Given that I've made it clear that ProductGroup is nullable shouldn't
this join be a left outer? Is there some reason it isn't? Is there a
work around?
Thanks.
--
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.
