CODEWITHSUNDEEP
c#entity-frameworkasp.net-web-apibreeze
Ali B
Ali B

Reputation: 1117

Counts in Breeze.js

I have a complex query that returns item counts. If I run a query on the client, will it always return the objects, or is there a way to just return the item counts without sending the object array in the payload? I tried doing something like

var query = breeze.EntityQuery.from('Items').inlineCount(true);

but that still pulls all the records down. Any solutions?

Upvotes: 5

Views: 2282

Answers (3)

user3335802
user3335802

Reputation: 27

var query = breeze.EntityQuery.from('Items') .take(0) .inlineCount(true);

Upvotes: -2

Jay Traband
Jay Traband

Reputation: 17052

The inlineCount answer already provided is absolutely correct.

Another alternative is to calculate the counts on the server and just send down the "summary". For example this server side controller method will return an array of two element objects to the client:

  [HttpGet]
  public Object CustomerCountsByCountry() {
    return ContextProvider.Context.Customers.GroupBy(c => c.Country).Select(g => new {g.Key, Count = g.Count()});
  }

This would be called via

  EntityQuery.from("CustomerCountsByCountry")
     .using(myEntityManager).execute()
     .then(function(data) {

     var results = data.results;
     results.forEach(function(r) {
       var country = r.Key;
       var count = r.Count
     });

  });

Upvotes: 6

PW Kad
PW Kad

Reputation: 14995

I don't know if this exactly answers your question, but you would need to query the records in order to know how many there are (to my knowledge, there may be a more efficient way to tie Breeze directly into a SQL command that is way over my head) so you could do something like - 

var query = breeze.EntityQuery.from('Items')
    .take(0)
    .inlineCount(true);

Edited the answer - this would return no objects and simply get the count.

Upvotes: 8

Related Questions