How do I count the number of rows in a table using the .NET Framework Data Provider for mySAP Business Suite

Question

SELECT count(*) FROM myTable does not seem to work when connected to an SAP-database with the ADO.NET Data Provider for mySAP Business Suite. Any ideas on how I can count the number of rows that a table contains without actually returning all the rows?

Therese is a reference for the SELECT statement here, but it didn't help much: http://msdn.microsoft.com/en-us/library/cc185153.aspx