Whats wrong with two calls? They are small and quick queries. Databases are designed to support lots of small queries.
A developing a complex solution to do one query for paging isn’t going give you much pay off.
More Related Contents:
- How do I view the SQL generated by the Entity Framework?
- Entity Framework – Why explicitly set entity state to modified?
- Convert value when mapping
- ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
- Entity Framework code first unique column
- How to include a child object’s child object in Entity Framework 5
- How do you update an edmx file with database changes?
- Entity framework code-first null foreign key
- EF Query With Conditional Include
- Entity Framework 4.2 exec sp_executesql does not use indexes (parameter sniffing)
- Multi-async in Entity Framework 6?
- Set decimal(16, 3) for a column in Code First Approach in EF4.3 [duplicate]
- How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
- ef core 2 apply HasQueryFilter for all entity
- Value cannot be null. Parameter name: entitySet
- Entity Framework and calling context.dispose()
- SQL Server Express connection string for Entity Framework Code First
- Entity Framework Code First – Advantages and disadvantages of Fluent Api vs Data Annotations [closed]
- EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
- EF Code First DBContext and Transactions
- How can I disable migration in Entity Framework 6.0
- Error 6002: The table/view does not have a primary key defined
- How do I use Entity Framework in Code First Drop-Create mode?
- Many to Many Relationships not saving
- DbContext AutoDetectChangesEnabled set to false detecting changes
- Using the Entry().CurrentValues.SetValues() is not updating collections
- ADO.NET Entity Framework tutorials [closed]
- Compose queries across Entity Data Models
- .NET 4.5 Beta DbGeography NotImplementedException
- An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key