Return a count with linq-to-sql

Question

Hi,

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

I am assuming you have a IEnumberable list called users and some variable called somedate.

int count = users
   .Where<User>(i => i.dateJoined > someDate)
   .Count<User>();

This will work against any IEnumberable list not just Linq to Sql

Answer 2

(from u in context.Users where u.dateJoined > date select u).Count()

Answer 3

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.