how get record count using linq to devforce

I've a query like this :

IEntityQuery<testTable> query = (from r in mgr.testTables where [condition] select r);

Now I want to get count of selected records, in linq to sql its possible to do this by adding .Count() at the end of linq query.

Here how can i get count of some special records ?

No, I dont mean get count of an argument of type IEnumerable ! I know how do that !!!

I need to get record count of a database table (I exactly mean something like SQL COUNT function).

Edited by ehsan - 25-Jun-2010 at 10:16pm

Just as with standard LINQ or LINQ to EF, you can add the Count() operator to your query.  Count() is an "immediate execution" operator, which means you can't build a query containing the operator as you can with the usual deferred execution types of operators.  So you can do something like this: 

 

int ct = (from r in mgr.testTables where [condition] select r).Count();

 

If you're working in Silverlight then the query needs to be executed asynchronously, so you can do it like this:

      var op = (from r in mgr.testTables where [condition] select r).AsScalarAsync().Count();
      op.Completed += (o, e) => {
        int ct = e.Result;
      };