title: EF core Linq groupby and having sum count - could not be translated and will be evaluated locally
body: <p>Following .net core EF core, Linq cannot be translated and will be evaluated locally. Can you please give me an advise?</p>
  
  <pre><code>var temp1= (from so in context.OrderShippingOrders
              group so by so.OrderId into g
              where g.Count(x=&gt; x.IsSent == true ) == g.Count()
              select new {
                          g.Key
                         }
             );
  
              query = (from o in context.Orders
                       join s in temp1
                       on o.Id equals s.Key
                       select o
                       );
  </code></pre>
  
  <p>The LINQ expression 'join AnonymousObject _o in {from Order o in value(Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable<code>1[ECommerce.API.Models.Order]) where ([o].ShopId == __queryObj_ShopId_Value_0) join &lt;&gt;f__AnonymousType18</code>1 s in {from IGrouping<code>2 g in {from OrderShippingOrder so in value(Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable</code>1[ECommerce.API.Models.OrderShippingOrder]) orderby [so].OrderId asc, [so].OrderId asc select [so] => GroupBy([so].OrderId, [so])} where ({from OrderShippingOrder x in [g] where ([x].IsSent == True) select [x] => Count()} == {[g] => Count()}) select new &lt;>f__AnonymousType18<code>1(Key = [g].Key)} on [o].Id equals [s].Key orderby EF.Property(?[o]?, "Id") asc select new AnonymousObject(new [] {Convert(EF.Property(?[o]?, "Id"), Object)}) =&gt; Skip(__p_1) =&gt; Take(__p_2) =&gt; Distinct()} on Property([o.OrderDetails], "OrderId") equals Convert([_o].GetValue(0), Nullable</code>1)' could not be translated and will be evaluated locally.</p>