CODEWITHSUNDEEP
linq-to-sql
mrblah
mrblah

Reputation: 103487

Return a count with linq-to-sql

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?

Upvotes: 13

Views: 21923

Answers (3)

Joseph
Joseph

Reputation: 25513

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.

Upvotes: 18

Adam Robinson
Adam Robinson

Reputation: 185603

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

Upvotes: 2

David Basarab
David Basarab

Reputation: 73301

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

Upvotes: 1

Related Questions