System.InvalidOperationException : The LINQ expression 'x => (int?)x > EntityShaperExpression: 
    ....Product
    ValueBufferExpression: 
        ProjectionBindingExpression: EmptyProjectionMember
    IsNullable: False
.DaysToManufacture' could not be translated. ...
Stack Trace: 
RelationalSqlTranslatingExpressionVisitor.VisitLambda[T](Expression`1 lambdaExpression)
Expression`1.Accept(ExpressionVisitor visitor)
ExpressionVisitor.Visit(Expression node)
RelationalSqlTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
NpgsqlSqlTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCall)
MethodCallExpression.Accept(ExpressionVisitor visitor)
ExpressionVisitor.Visit(Expression node)
RelationalSqlTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCallExpression)
NpgsqlSqlTranslatingExpressionVisitor.VisitMethodCall(MethodCallExpression methodCall)
MethodCallExpression.Accept(ExpressionVisitor visitor)
<12 more frames...>
QueryCompiler.CompileQueryCore[TResult](IDatabase database, Expression query, IModel model, Boolean async)
<>c__DisplayClass9_0`1.<Execute>b__0()
CompiledQueryCache.GetOrAddQuery[TResult](Object cacheKey, Func`1 compiler)
QueryCompiler.Execute[TResult](Expression query)
EntityQueryProvider.Execute[TResult](Expression expression)
EntityQueryable`1.GetEnumerator()
List`1.ctor(IEnumerable`1 collection)
Enumerable.ToList[TSource](IEnumerable`1 source) 

                var ids = new Guid[] { Guid.NewGuid(), Guid.NewGuid() };
                context.Set<Product>().Where(p => ids.Any(x => x == p.rowguid)).Count();
                context.Set<Product>().Select(p => ids.Any(x => x == p.rowguid)).ToList();
                //context.Set<Product>().Select(p => ids.Where(x => x == p.rowguid).Any()).ToList();//1
                //context.Set<Product>().Select(p => ids.Where(x => x == p.rowguid).Count()).ToList();//2
                //context.Set<Product>().Select(p => ids.Count(x => x == p.rowguid)).ToList();//3
                var idsQ = ids.AsQueryable();
                //context.Set<Product>().Where(p => idsQ.Any(x => x == p.rowguid)).Count();//4
                context.Set<Product>().Where(p => idsQ.AsEnumerable().Any(x => x == p.rowguid)).Count();
                context.Set<Product>().Select(p => idsQ.AsEnumerable().Any(x => x == p.rowguid)).Count();
                //context.Set<Product>().Select(p => idsQ.AsEnumerable().Where(x => x == p.rowguid).Any()).ToList();//5
                //context.Set<Product>().Select(p => idsQ.AsEnumerable().Where(x => x == p.rowguid).Count()).ToList();//6
                //context.Set<Product>().Select(p => idsQ.AsEnumerable().Count(x => x == p.rowguid)).ToList();//7
                var vals = new int[] { 1, 5 };
                context.Set<Product>().Select(p => vals.Any(x => x > p.DaysToManufacture)).ToList();
                //context.Set<Product>().Select(p => vals.Where(x => x > p.DaysToManufacture).Count()).ToList();//8
                //context.Set<Product>().Select(p => vals.Count(x => x > p.DaysToManufacture)).ToList();//9
                //context.Set<Product>().Where(p => vals.Where(x => x > p.DaysToManufacture).Any()).Count();//10
                //context.Set<Product>().Where(p => vals.AsEnumerable().Where(x => x > p.DaysToManufacture).Any()).Count();//11
                var valsQ = vals.AsQueryable();
                //context.Set<Product>().Select(p => valsQ.AsEnumerable().Where(x => x > p.DaysToManufacture).Count()).ToList();//12
                var valsStr = string.Join(",", vals);
                var valsQuery = context.Database.SqlQuery<int>($"select unnest(string_to_array({valsStr},',')::int[]) as value");
                //var query = context.Set<Product>().Where(p => valsQuery.Where(x => x > p.DaysToManufacture).Any()).ToList();//13
                // Npgsql.PostgresException : 42703:
                // something like "column t.Value not exists"

                //context.Set<Product>().Select(p => new { p, vals }).SelectMany(x => x.vals.Select(v => new { x.p, v }))
                //    .Where(c => c.v > c.p.DaysToManufacture).Count();//14
                object value = context.Set<Product>().SelectMany(t1 => context.Set<Product>(), (t1, t2) => new { Id1 = t1.rowguid, Id2 = t2.rowguid }).ToList();
                //context.Set<Product>().SelectMany(te => valQ.AsEnumerable(), (t1, t2) => new { Id = t1.rowguid, r = t2 }).ToList();//15
                //context.Set<Product>().SelectMany(te => valQ, (t1, t2) => new { Id = t1.rowguid, r = t2 }).ToList();//16
                //context.Set<Product>().SelectMany(te => vals, (t1, t2) => new { Id = t1.rowguid, r = t2 }).ToList();//17
                //context.Set<Product>().GroupJoin(vals, x => true, x => true, (p, ranges) =>
                //    new
                //    {
                //        p = p,
                //        r = ranges.Where(rr => rr > node.DaysToManufacture).First()
                //    }
                //).ToList(); //18
                context.Set<Product>().Select(p => vals.Where(x => x > p.DaysToManufacture).First()).Count();
                //context.Set<Product>().Select(p => vals.Where(x => x > p.DaysToManufacture).First()).ToList();//19
                //context.Set<Product>().Select(p => new { p = p, r = vals.Where(x => x > p.DaysToManufacture).First() })
                //    .GroupBy(x => x.r, (key, list) => new { r = key, count = list.Count() }).ToList();//20