How do I do this in Linq

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi,

Sample query... how do I write it in linq?

SELECT UserName, COUNT(UserName) AS Expr1
FROM aspnet_Users
WHERE (LastActivityDate BETWEEN '23 March 2009' AND '10 April 2009')
GROUP BY UserName

I have tried...


var users = from Users in dc.aspnet_Users
where Users.LastActivityDate >= "23 March 2009"
where Users.LastActivityDate <= "10 April 2009"
group Users by Users.UserName into g
select new
{
Key = g.Key, Count = g.Count()
};

but it doesn't work. (problem with >= and <=)

I am new to linq (still attempting to get my head around it). I am not even
sure if g.Key and g.Count() are what I am looking for. All I know is I want
to be able to return a resultset like the sample query.

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available
 
David said:
However, I have key and count, what if I want to select more items in my
initial select or have further counts?
Click to expand...

counts of what exactly? Currently, with

var users = from Users in dc.aspnet_Users

group Users by Users.UserName into g
select new
{
Key = g.Key, Count = g.Count()
};

you count the items in each group g.
 
so, if I do something like...

group Users by Users.UserName into g
group Users by Users.LoweredUserName in h

I can then do h.Key and h.Count() as well as g.Key and g.Count() in select?

(I am getting a bit ahead of myself here... but is the theory there?)

--
Best regards,
Dave Colliver.
http://www.AshfieldFOCUS.com
~~
http://www.FOCUSPortals.com - Local franchises available
 
Back
Top