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

aaarrrggghhh!!!

When I read the error message properly, I found the fix. Doh!!!

Convert.ToDateTime() of my date strings.

However, I have key and count, what if I want to select more items in my
initial select or have further counts?

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


"David" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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 wrote:

> However, I have key and count, what if I want to select more items in my
> initial select or have further counts?

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.


--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

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
"Martin Honnen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> David wrote:
>
>> However, I have key and count, what if I want to select more items in my
>> initial select or have further counts?
>
> 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.
>
>
> --
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/