c＃和SQL服务器相当于PHP中的mysql_num_rows

Question

I am trying to find the number of rows selected by a select query in ASP.Net - I am using an SQL server database. What is the c# equivalent to PHP's mysql_num_rows?

Answer 1

System.Data.SqlClient

SqlDataReader has the RecordsAffected Property to get that value, except for select statements. Therefore you have to count manually or use a SELECT COUNT(*) in your SQL statement.

EntityFramework

Have a look a this article.

LINQ2SQL

var pupilCOunt = (from p in schoolContext.Pupils select p).Count();