EqProperty cannot be used to generate joins.You have to call CreateCriteria
in order to do that.
On Tue, Oct 28, 2008 at 1:20 PM, PaulKetelle <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm currently using NHQG for a new project I am working on. I'm
> currently having a small issue with a query.
>
> In essence what I want is the following:
>
> SELECT TOP 1 * FROM CMS_Pages
> INNER JOIN CMS_PagesDocuments ON CMS_Pages.PageID =
> CMS_PagesDocuments.PageID
> INNER JOIN CMS_Documents ON CMS_Documents.DocumentID =
> CMS_PagesDocuments.DocumentID
> INNER JOIN CMS_DocumentTypes ON CMS_DocumentTypes.DocTypeID =
> CMS_Documents.DocTypeID
> WHERE CMS_Documents.RecordID = recordId
> AND CMS_DocumentsTypes.TableName = tableName
> AND CMS_Pages.TemplateID = CMS_Documents.SubTemplateID
>
> So far I have the following code:
>
> CMS_Pages PageData =
> Repository<CMS_Pages>.FindFirst(
>
>
> Where.CMS_Pages.PageDocs.With(JoinType.InnerJoin).CMS_Documents.CMS_DocumentTypes.TableName
> ==
> tableName &&
>
> Where.CMS_Pages.PageDocs.With(JoinType.InnerJoin).CMS_Documents.RecordID
> ==
> recordId &&
>
>
> Where.CMS_Pages.TemplateID.EqProperty("PageDocs.CMS_Documents.CMS_DocumentTypes.SubPageTemplateID"));
>
> however this is failing. The bit it doesn't like is the EqProperty
> part. Ideally I'd like to get away from using strings and using
> property names instead, so I'm guessing I've built up the query
> incorrectly. Any advice would be much appreciated.
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" 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/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
