Untitled

from doc in docs

where doc["@metadata"]["Raven-Entity-Name"] == "Derivatives"

select new {

Id = doc.__document_id, doc.DerivativeType, doc.Manufacturer, doc.Range, doc.BodyStyle, doc.FuelType, doc.Transmission,  doc.DerivativeName, doc.Introduced,

QueryPath = doc.DerivativeType + "/"  +

doc.Manufacturer + "/" +

doc.Range + "/" +

doc.BodyStyle + "/" +

doc.FuelType + "/" +

doc.Transmission

}