public virtual async Task <int> GetCount(string query = "") { var sql = "SELECT COUNT(1) AS CNT FROM PRODUCT WHERE 1=1 " + query; var result = await DBManager <PRODUCT> .ExecuteScalar(sql); return(Convert.ToInt32(result)); }
public async Task <int> SpecialCount() { var sql = string.Format(@" SELECT SUM (row_count) FROM sys.dm_db_partition_stats WHERE object_id=OBJECT_ID('PRODUCT') AND (index_id=0 or index_id=1); "); var result = await DBManager <PRODUCT> .ExecuteScalar(sql); return(Convert.ToInt32(result)); }