public void CountSql_Test() { var sqlQuery = "SELECT ID AS Num, Name, Age, Weight, Address, Enabled, CreatedDate FROM TestTemp"; var countSql = new SqlSelectCountClauseBuilder(sqlQuery); var result = countSql.ToString(); Assert.Fail(result); }
public async Task <int> GetRecordCountAsync(string sqlQuery, object param = null) { var sqlBuilder = new SqlSelectCountClauseBuilder(sqlQuery); return(await this.Connection.ExecuteScalarAsync <int>(sqlBuilder.ToString(), param)); }
/// <summary> /// 获取存储容器中的对象数量 /// </summary> /// <param name="sqlQuery">SQL 查询语句 /// 注:用具体的列名,不要使用 * 匹配符</param> /// <param name="param">查询参数</param> /// <returns><see cref="System.Int32"/></returns> public int GetRecordCount(string sqlQuery, object param = null) { var sqlBuilder = new SqlSelectCountClauseBuilder(sqlQuery); return(this.Connection.ExecuteScalar <int>(sqlBuilder.ToString(), param)); }