How do I get the number of rows in the set(linq)

[Tony Johansson]

Hello!

If I for example have this set names query or some other set which has been
returned by using linq how
do I get the number of rows in th set ?
var query = from row in table1.AsEnumerable()
join bar in doc.Root.Elements("bar")
on row.Field<int>("k") equals
(int)bar.Attribute("k")
select new { key = row.Field<int>("k"),
foo = row.Field<string>("foo"), bar =
(string)bar.Attribute("bar") };

//Tony

[Duggi]

On Sep 19, 5:01*pm, "Tony Johansson" <[e-mail]:

Hello!

If I for example have this set names query or some other set which has been
returned by using linq how
do I get the number of rows in th set ?

var query = from row in table1.AsEnumerable()
* * * * * * * * * * * * *join bar in doc.Root.Elements("bar")
* * * * * * * * * * * * *on *row.Field<int>("k") equals
(int)bar.Attribute("k")
* * * * * * * * * * * * *select new { key = row.Field<int>("k"),
* * * * * * * * * * * * *foo = *row.Field<string>("foo"), bar =
(string)bar.Attribute("bar") };

//Tony

int i = ( from row in table1.AsEnumerable()
join bar in doc.Root.Elements("bar")
on row.Field<int>("k") equals
(int)bar.Attribute("k")
select new { key = row.Field<int>("k"),
foo = row.Field<string>("foo"), bar =
(string)bar.Attribute("bar") }).Count();

<code>

int count = (From <tablein database select <items>) .count();

</code>

should work.