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.AsEnumer able()
join bar in doc.Root.Elemen ts("bar")
on row.Field<int>( "k") equals
(int)bar.Attrib ute("k")
select new { key = row.Field<int>( "k"),
foo = row.Field<strin g>("foo"), bar =
(string)bar.Att ribute("bar") };

//Tony

[Duggi]

On Sep 19, 5:01*pm, "Tony Johansson" <t.johans...@lo gica.comwrote:

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.AsEnumer able()
* * * * * * * * * * * * *join bar in doc.Root.Elemen ts("bar")
* * * * * * * * * * * * *on *row.Field<int> ("k") equals
(int)bar.Attrib ute("k")
* * * * * * * * * * * * *select new { key = row.Field<int>( "k"),
* * * * * * * * * * * * *foo = *row.Field<stri ng>("foo"), bar =
(string)bar.Att ribute("bar") };

//Tony

int i = ( from row in table1.AsEnumer able()
join bar in doc.Root.Elemen ts("bar")
on row.Field<int>( "k") equals
(int)bar.Attrib ute("k")
select new { key = row.Field<int>( "k"),
foo = row.Field<strin g>("foo"), bar =
(string)bar.Att ribute("bar") }).Count();

<code>

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

</code>

should work.