execute a select count sql in c#

Question

I am trying to execute a simple sql select statement using C# and I want to return the number of rows.  What is the correct syntax.

SELECT Count(*) FROM InvData