SQL cannot be converted to LINQ: SQL with sub join

[pbpati123]

Hi
I have the following SQL Statement. Linquer is complaining that it cannot convert this to Linq.



select *

from
(

SELECT Catalog.Element.ElementNumber, Catalog.Element.Description, Catalog.AttributeValue.Value, Catalog.Attribute.Name
FROM Catalog.Element INNER JOIN
Catalog.ElementAttributeValue ON Catalog.Element.ElementID = Catalog.ElementAttributeValue.ElementID INNER JOIN
Catalog.AllowedSubComponents ON Catalog.ElementAttributeValue.AttributeValueID = Catalog.AllowedSubComponents.AttributeValueIDFilter AND
Catalog.Element.ElementClassID = Catalog.AllowedSubComponents.ClassIDFilter INNER JOIN
Catalog.ElementAttributeValue AS ElementAttributeValue_1 ON Catalog.Element.ElementID = ElementAttributeValue_1.ElementID INNER JOIN
Catalog.AttributeValue ON ElementAttributeValue_1.AttributeValueID = Catalog.AttributeValue.AttributeValueId INNER JOIN
Catalog.Attribute ON Catalog.AttributeValue.AttributeID = Catalog.Attribute.AttributeID
WHERE (Catalog.AllowedSubComponents.ElementID = '8c139311-f7cd-4961-a8bb-0d8dd923049e') AND (Catalog.Attribute.Name = N'MODULE_TYPE') OR
(Catalog.Attribute.Name = N'MANUFACTURER')
) as up
pivot ( max(up.Value) for up.Name in([MANUFACTURER],[MODULE_TYPE])) AS pvt

[Mikhail Oumantsev]

PIVOT and UNPIVOT conversion is not supported because of LINQ restrictions.