How To Build Recursive a LINQ Query in Net Core 3.1 To Generate SQL Queries .

[lucianparvu]

How can I build recursively a linq Query generate this type of SQL Query from Net Core 3.1 C#, EF Core

SELECT * 
FROM [ViewAdminProductAtributeV2HintView] AS [v] 
where EXISTS (
      SELECT 1
      FROM [ViewAdminProductAtributeV2HintView] AS [v0] 
      WHERE [v].[ProductID] = [v0].[ProductID]  AND  [v0].[AtributeID] = 61   AND [v0].[AtributeValueID] IN (224)    
      And Exists
	 (
		 SELECT 1
                 FROM [ViewAdminProductAtributeV2HintView] AS [v1]
		 where [v1].[ProductID] = [v0].[ProductID] and [v1].[AtributeID] = 62   AND [v1].[AtributeValueID] IN (371)	
		 
		 And Exists
		 (
			 SELECT 1
			 FROM [ViewAdminProductAtributeV2HintView] AS [v2]
			 where [v2].[ProductID] = [v1].[ProductID] and [v2].[AtributeID] = 119   AND [v2].[AtributeValueID] IN (1534)
		 )
	 )
) 

And I have this function :

public static async Task<List<ViewAdminProductAtributes>> GetResults(this DbSet<ViewAdminProductAtributes> source, ApplicationDbContext context, List<UrlFilter> Filters)
 { 	
        var productAtibutesQuery = context.ViewAdminProductAtributes.AsQueryable();
 
      / Maybe Should Be :
        productAtibutesQuery = productAtibutesQuery.Where(pf => context.ViewAdminProductAtributes
                        .Any(y =>
                                pf.ProductID == y.ProductID && y.AtributeID == @RecursiveAtributeID && atributeValuesRecursive.Contains(y.AtributeValueID)     
                                
                                && y.Any(... )                                                    
                                 
                        ));

     return await productAtibutesQuery.AsNoTracking().ToListAsync();
}

public class UrlFilter
 {
        public int AtributeID { get; set; }
        public int  AtributeValueID { get; set; }        
 }

I have Looked at Expressions & Functions , but i can't figure how to do it .