如何编写C#代码以返回数据库表中用于仪表板显示的用户计数

Question

public static MemberCountsModel UCount { get; private set; }
public static MemberCountsModel GetMemberCount()
{
dbFactorySetup.InitializeDBSettings();
DbConnection SQLConn;
var dbPF = dbFactorySetup.GetDbProviderFactory();
try
{                             
using (SQLConn = dbPF.CreateConnection())
{
SQLConn.ConnectionString = dbFactorySetup._conn;
SQLConn.Open();
using (DbCommand SQLCmd = SQLConn.CreateCommand())
{                       
DateTime DefaultDate = new DateTime(1, 1, 1, 0, 0, 0, DateTimeKind.Utc);
SQLCmd.CommandText = dbFactory.TransformSQL(SQL.GetMemberCount, dbFactorySetup._dbType);
long UCount = 0;
UCount = (long)SQLCmd.ExecuteScalar();
}
}
return UCount;
}
catch (Exception ex)
{
throw ex;
}
}

我正在尝试使用上面的代码计算数据库表中的成员数。虽然它返回一个204 StatusCode，但没有返回任何值。我做错了什么？注意：SQL=GetMemberCount=SELECT COUNT(1(FROM用户/SELECT COUNT。使用了任何SQL语句。

Answer 1

您需要在主键上使用groupby才能计数。

SELECT COUNT(*)
FROM table
GROUP BY primarykey`