In SQL you would use the following query to get the count of number of rows in a table.

Select count(*) from tblMyData

 

In LINQ

 

In VB.NET you would use the following to get it

 

  Dim v = (From u In MyContext.MyTable).Count()

 

 

In C# you would use the following syntax

 

var v= (from u in MyContext.MyTable).Count();

You variable v will not contain the count