This question is locked. New answers and comments are not allowed.
Hi,
I am using a join statement with 3 tables and on fetching the results me in a statement saying "Telerik.OpenAccessQuery#3 not executed". I am post the sample query for you reference.
Dim query = From t1 In scope.Extent(Of Company)() _
Join t2 In scope.Extent(Of Company)() On t1.ParentCompany Equals t2.CompanyID _
Join t3 In scope.Extent(Of Codes)() On t1.CompanyType Equals t3.CodeID _
Select New With {t1.CompanyID, Key .CompanyName = t1.CompanyName, Key .CompanyType = t3.CompanyType, Key .ParentCompany = t2.CompanyName}
Please help me in getting this solved soon.
Thanks
Srinivas
I am using a join statement with 3 tables and on fetching the results me in a statement saying "Telerik.OpenAccessQuery#3 not executed". I am post the sample query for you reference.
Dim query = From t1 In scope.Extent(Of Company)() _
Join t2 In scope.Extent(Of Company)() On t1.ParentCompany Equals t2.CompanyID _
Join t3 In scope.Extent(Of Codes)() On t1.CompanyType Equals t3.CodeID _
Select New With {t1.CompanyID, Key .CompanyName = t1.CompanyName, Key .CompanyType = t3.CompanyType, Key .ParentCompany = t2.CompanyName}
Please help me in getting this solved soon.
Thanks
Srinivas