try someting like:






var Members = Member.GetAll.Count(g=>g.getProperty("City") == "San Carlos")

var Members = Member.GetAll.Count(g=>g.getProperty("City").Value.ToString() == "San Carlos")

You should probably assign the Member.GetAll to a local variable before doing the lambda expression. I'm not quite sure how the GetEnumerator() method is evaluated by the runtime engine but the GetAll accessor executes a database query. For example these two statements hit the database which returns every record each time:

var first = Member.GetAll[0];
var count = Member.GetAll.Length;

If you have 100 members all 100 members are returned each time, regardless of what you want.

But if I was to do this:

var members = Members.GetAll;
var first = members[0];
var count = members.Length

We only do a single DB call (yes, to return all 100 members though) rather than two.

Interesting, thanks. Right now I'm executing a scalar sqlserver function that I put into the database:

ALTER FUNCTION [dbo].[sfNumberOfMembers]
(
)
RETURNS int
AS
BEGIN
    DECLARE @retVal int = (SELECT COUNT(nodeId) FROM cmsMember)

    RETURN @retVal

END

I'm pretty sure this is valid, although it's undesirable to be tied that closely to the table structure in case it changes.

- Mark

is working on a reply...