Hey, I've noticed that if I write a query that puts a condition on a related entity's primary key, such as
_queryService.IndexedUrl.Where(t=>t.Author.Id == 29) then nHibernate will join on the Author table, even though it only actually needs to specify "AuthorId" on the IndexedUrl table as we're not returning any rows from the related Author entity. Unfortunately it doesn't look like the database query optimizers realise this either. Is there any way I can force nHibernate to do the "right" thing? Thanks! James --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
