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));
}
