How to group by on 2 child entities and get total of both this child entities?

by

Update

Ok Learning, here it is a solution..

var tot_variants_for_test =
    (from v_name in 
       (from t_op in test 
        select new { v_name = t_op.TestOperation.Select(sv => sv.SubVariants.Variants.Name) }
       ).First().v_name 
     select v_name)
    .Union(
    (from v_name in 
      (from t_opdf in test 
       select new { v_name = t_opdf.TestOperationDifference.Select(sv => sv.SubVariants.Variants.Name) }
     ).First().v_name
     select v_name))
   .Count();

More Related Contents:

  1. Filter/Search using Multiple Fields – ASP.NET MVC
  2. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  3. The operation cannot be completed because the DbContext has been disposed using MVC 4
  4. Export Model to DataTable
  5. Only primitive types or enumeration types are supported in this context
  6. Dynamic where clause (OR) in Linq to Entities
  7. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  8. Bulk-deleting in LINQ to Entities
  9. Entity framework left join
  10. Why doesn’t Include have any effect?
  11. Value cannot be null. Parameter name: source
  12. Recursive Hierarchy – Recursive Query using Linq
  13. How to do a Bulk Insert — Linq to Entities
  14. How to convert an expression tree to a partial SQL query?
  15. Generate EF orderby expression by string [duplicate]
  16. MVC 4 how pass data correctly from controller to view
  17. Entity-framework code is slow when using Include() many times
  18. How does LINQ expression syntax work with Include() for eager loading
  19. Simulating Cross Context Joins–LINQ/C#
  20. Max return value if empty query
  21. Keyword Not Supported: Metadata
  22. Check if list contains item from other list in EntityFramework
  23. Entities VS Domain Models VS View Models
  24. How to do an “in” query in entity framework?
  25. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  26. Where can I find the System.Linq.Dynamic dll?
  27. How to wrap Entity Framework to intercept the LINQ expression just before execution?
  28. Repository Pattern, POCO, and Business Entities
  29. .NET Managing Layers Relationships
  30. Entity Framework Many to many through containing object

Leave a Comment