Return a count with linq-to-sql

Question

I want to return a count of new users since a specific date.

Users table has: UserID, username, dateJoined.

SELECT COUNT(USERID)
FROM Users
where dateJoined > @date

How would this look in linq-to-sql?

Can you use the keyword COUNT?

Answer 1

You can go two routes:

var count = (from u in context.Users where u.datJoined > date select u).Count();

or

var count = context.Users.Where( x => x.datJoined > date).Count();

Both are equivalent, it really boils down to a matter of personal preference.