How to COUNT rows within EntityFramework without loading contents?

by

Query syntax:

var count = (from o in context.MyContainer
             where o.ID == '1'
             from t in o.MyTable
             select t).Count();

Method syntax:

var count = context.MyContainer
            .Where(o => o.ID == '1')
            .SelectMany(o => o.MyTable)
            .Count()

Both generate the same SQL query.

More Related Contents:

  1. Entity Framework .Remove() vs. .DeleteObject()
  2. Bulk-deleting in LINQ to Entities
  3. EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship
  4. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  5. How to disable cascade delete for link tables in EF code-first?
  6. c# working with Entity Framework in a multi threaded server
  7. How to compare only Date without Time in DateTime types?
  8. Check if list contains item from other list in EntityFramework
  9. How to use String property as primary key in Entity Framework
  10. import csv file to sql database in c# window application without header row [duplicate]
  11. Entering keys manually with Entity Framework
  12. The cast to value type ‘Int32’ failed because the materialized value is null
  13. Entity framework left join
  14. What are the downsides to turning off ProxyCreationEnabled for CTP5 of EF code first
  15. Entity Framework. Delete all rows in table
  16. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  17. Place to put Database.SetInitializer
  18. Finding the reason for DBUpdateException
  19. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  20. GUID COMB strategy in EF
  21. Simulating Cross Context Joins–LINQ/C#
  22. Can you get the DbContext from a DbSet?
  23. Entity Framework core – Contains is case sensitive or case insensitive?
  24. Why is EF generating SQL queries with unnecessary null-checks?
  25. Entities VS Domain Models VS View Models
  26. How to do an “in” query in entity framework?
  27. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  28. The ObjectContext instance has been disposed and can no longer be used for operations that require a connection [duplicate]
  29. How to create custom additional fields in UserProfile in MVC4
  30. Entity Framework Code First naming conventions – back to plural table names?

Leave a Comment