Written a query in postgresql but facing problem while writing into entity framework

See more:

PostgreSQL

entity-framework

Written a query in postgresql but facing problem while writing into entity framework.
See my query below:

What I have tried:

SELECT  
C."DetailedDescription" , S."DemoVideoTypeUId", S."DemoVideo",
        ( SELECT json_agg( row_to_json(B))  AS "Feature" FROM (
        SELECT DISTINCT "FeatureTitle", "FeatureDescription"
        FROM catalogueservices."AssetFeature" 
        WHERE  "AssetVersionUId" = V."AssetVersionUId" AND "AssetUId" = V."AssetUId"
        )B
         ) AS "Feature",
        ( SELECT json_agg(row_to_json(B))FROM (
        SELECT DISTINCT "AssetOutcomeOrBenefitUId",
                ( SELECT DISTINCT "MasterListItemValue" FROM catalogueservices."MasterListItem" 
                             WHERE "MasterListItemUId" = "OutcomeTypeUId") AS "OutcomeType",
      "OutcomeValue", "OutcomeDesc", "Tagwords"
        FROM catalogueservices."AssetOutcomeOrBenefit" 
        WHERE "AssetVersionUId" = V."AssetVersionUId"
        )B
       ) AS "Benefit",
       ( SELECT json_agg( row_to_json(B))  AS "Feature" FROM (
        SELECT DISTINCT A."DisplayName", A."EmailId", R."RoleName"
        FROM catalogueservices."AssetContact" A
        JOIN catalogueservices."Role" R ON A."RoleUId" = R."RoleUId"
        WHERE A."AssetUId" = C."AssetUId" -->AND A."AssetVersionUId" = V."AssetVersionUId"
        )B
         ) AS "Contact",
      
       CS."AssetImagePath", CS."AssetImageBinary" ,
       CS."AssetImageTypeUId" , Q."Comments" 
       
 from catalogueservices."AssetDetails" C
 JOIN catalogueservices."AssetVersion" V ON C."AssetUId"= V."AssetUId" 
 left JOIN catalogueservices."AssetImage" CS ON C."AssetUId"= CS."AssetUId" 
 left JOIN catalogueservices."AssetDemoVideo" S ON C."AssetUId" = S."AssetUId"
 left JOIN catalogueservices."DemoVideoSection" Q ON S."AssetDemoVideoUId"= Q."AssetDemoVideoUId"

  where C."AssetId"= '19'
and V."AssetVersionId"='22'